I need the UNMATCH data

[Marco]

Hi. I have a table that have named as querie1 that has record, imagine 1 to
100. I have table2 that have 50 record 1 to 50. Those 50 record of table2 are
equal to 50 record that exists in table1. I need a querie that shows me the
that the does not mach. That shows me the others 50 records.

Please help me.

Regards,
Marco

 

[John W. Vinson]

Hi. I have a table that have named as querie1 that has record, imagine 1 to
100. I have table2 that have 50 record 1 to 50. Those 50 record of table2 are
equal to 50 record that exists in table1. I need a querie that shows me the
that the does not mach. That shows me the others 50 records.

Create a new Query. Use the "Unmatched Query Wizard".

If you can't find it or have trouble, post back; it would help if you indicate
the Primary Key field of each table, and whether the tables have any
relationship defined.

John W. Vinson [MVP]