unmacth rows from both tables

J

JIM.H.

Hello,
I have two tables and I need to write a query that brings
all unmatch rows in both tables.
How can I do that?
Thanks,
Jim.
 
S

Sal Rosario

You can use the Find Unmatched query wizard.
1. Activate the Queries tab.
2. Click on the New button.
3. Choose Find Unmatched
4. Follow the wizard steps.

Good luck!
 
J

JIM.H.

It seem it brings the rows in the first table not both. Am
I mistaking?
Thanks,
Jim.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query comparing two fields in a table gives wrong results-why? 3
Find unmatched query with selected date 2
Help! Unmatched Data Query 1
untach rows 2
Query-finding umatched data with duplicates 5
Append Query is not working 1
Query automatically changing my source table 3
Query that will look for duplicate in two tables. 3

Top