General information
Category:
Database DAO/RDO/ODBC/ADO
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only