compare tables and get common data

C

Croco

hey everyone, i know it is a silly question but i am missing the most
critical part about it...

i have two tables "newest" and "removed". they both have two fields: Code
and Name. i want to compare the data in the Name field and get the common
records of the tables... tried the draging way but it showed me nothing...
while there are some coomon records i am sure...

thanks for your help in advance ...
 
O

Ofer Cohen

You need to create a select query with a Inner join between the two tables,
that way only the commomn records will display

Something like:

Select newest.* From newest Inner Join removed On newest.Code = removed.Code

Or, create a query, add both tables and then create a connection between the
two tables with the code field, drag and drop from one table to the other
 
Top