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

comparing N pair of tables

P: 3
i want to compare n pair of tables.
i know to compare two tables the query is
table 1 is having following columns

uprn description blocknumber
1 gf 10
2 gf 20

and table2 is

uprn description blocknumber
1 gf 1
2 gf 20

SELECT table2.*
FROM table2 LEFT JOIN table1 ON (table2.UPRN=table1.UPRN) AND (table2.SchoolName=table1.SchoolName) AND (table2.Description=table1.Description)
WHERE (((table1.UPRN) Is Null));

in the same way i want to compare table3&table4
table4&table5 and so on -----table10&table11
i want to compare these tables and get result in one query please give me detailed discription for this.

Apr 19 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,427
Sounds like you're looking for a Union query.
Apr 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.