I am trying to compare two records from two tables.

[kavya]

I am trying to compare two records from two tables.
Tblu and tblsub and create a table tblunion with matched records.

Both the tables have a common field 'filename'.

Can some one give me the example of the code.

Thanks alot.

 

[bdmclennan]

Create a new query and paste this SQL in then Run it.


SELECT tblU.FILENAME INTO tblUNION
FROM tblU INNER JOIN tblSUB ON tblU.FILENAME = tblSUB.FILENAME ;

 

[kavya]

hi bdmclennan,

Thanks for your reply. But I was looking for code in module that opens the recordset and then does the comparison.
Thanks once again.