Comparing Tables

[k209310]

Hello

Is it possible to write a query that will compare two tables. This is hard to explain - i dont know the name of this kind of query so i cant do a search. I would be gratefull if someone could point me in the right direction..

Example.
Table1
Field1 Field2 Field3

Table2
Field1 Field2

I need to select Field3 from table1 where fields1 and fields2 match in the two tables. Does this make sense at all? Please get back to me if it doesnt.

Thanks

Chris

 

[neileg]

Create a query and add your tables. Create a relationship between field 1 in each table and then between field 2 in each table. Make sure they are type 1 joins (ie only inclue records where both fields match). Add field 1, 2 and 3 to the grid. Run the query.

 

[k209310]

Cheers mate, Worked a treat.