I need the UNMATCH data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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]
 
Back
Top