By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,469 Members | 2,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,469 IT Pros & Developers. It's quick & easy.

2 table only show records that don't match

P: n/a
I have to tables
Table1
IMS_ID
IMS_Name
IMS_Descript

Table2
P_IMS_ID
P_IMS_Name
P_IMS_Descript

I want to show records that are in Table1 but not in Table2 or
records that are in Table2 but not in Table1

Anyone doing anything like this and how did you do it. I want to make
this a report on my Switchboard.

Thanks
Steve
Oct 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Steve wrote:
I have to tables
Table1
IMS_ID
IMS_Name
IMS_Descript

Table2
P_IMS_ID
P_IMS_Name
P_IMS_Descript

I want to show records that are in Table1 but not in Table2 or
records that are in Table2 but not in Table1

Anyone doing anything like this and how did you do it. I want to make
this a report on my Switchboard.

Thanks
Steve
You can do a Query/New/Unmatched and let the wizard write the SQL statement.

Manually, you could do a Query/New/Design for Table1 as the first step.
Select/add the two tables. Drop the fields from Table1. Drop the
P_IMS_ID field from Table2 to a column as well. In the criteria enter
"Is Null" in the criteria row of the P_IMS_ID column. Then drag the
IMS_ID to P_IM_ID in table2 to create a link line between the two
tables. Then dblclick on the line and select the "Select All records in
Table1 and matching in Table2" option. Save and run. Reverse the
tables and fields to create the second query.

Oct 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.