I have a Table A and a Table B

Table A has 1 Field and all Records are unique


Example: Table A


Code

a001
a002
a003
a004
a005
a006
a007
a008
a009
a010


I want to find a005 from Table A


Table B has 2 Fields and no Record is unique; unless Both Fields are grouped


Code Category


a 001
a 002
a 003
a 004
a 005
a 006
a 007
a 008
a 009
a 010


I want to find the record were Code = a and Category = 005


Which Method is the most practical to use and faster???



Regards,

Johann