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

compare two table columns

P: n/a
hi there, new to this database mularkey and needing some advice.

I have two tables that I want to compare. If the results of each are
the same I award a mark. Can someone give me the general SQL statement
that I would need to achieve this.

any help here would be great.

relevent info?

using Access 97
VB.NET

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Go to the Queries tab in the main database window. Click on the New button
and choose the Unmatched Query wizard. This will return records from one
table that aren't in the other table on the field you are linking the two
by. If there are no records, then they all matched up. You will actually
need to do this twice (two queries), once each direction. The first time you
would look for records in Table2 that don't have a match in Table1, the
second time you would look for records in Table1 that don't have a match in
Table2.

--
Wayne Morgan
MS Access MVP
"dave_wheels" <m.*******@blueyonder.co.uk> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
hi there, new to this database mularkey and needing some advice.

I have two tables that I want to compare. If the results of each are
the same I award a mark. Can someone give me the general SQL statement
that I would need to achieve this.

any help here would be great.

relevent info?

using Access 97
VB.NET

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.