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

How to have query show differences between 2 tables?

P: n/a
Is there an easy way to have a query return only the differences between 2
tables?

something like...

SELECT * FROM tblA
UNION SELECT * FROM tblB
WHERE tblA.* <> tblB.*

????

thx.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
When creating a new query, select "Find Unmatched Query Wizard" from the
list. This will find all the records in the first table that are not in the
second table.

"deko" <dj****@hotmail.com> wrote in message
news:WF****************@newssvr29.news.prodigy.com ...
Is there an easy way to have a query return only the differences between 2
tables?

something like...

SELECT * FROM tblA
UNION SELECT * FROM tblB
WHERE tblA.* <> tblB.*

????

thx.

Nov 12 '05 #2

P: n/a
> When creating a new query, select "Find Unmatched Query Wizard" from the
list. This will find all the records in the first table that are not in the second table.

excellent... thanks
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.