connecting and comparing two databases

[deepu1]

HI

A school table is there in old and new data base,
if i give school key as 001 (which is the column of school table) i need to compare old database school table "001 key" and new database school table
"001 key" and if it is not matched it should be displayed.
Please give me detailed dicription with example.and
how to go and check two database if u give some data like schoolkey which is already present in the databases.

thanks
sravani

[deepu1]

hi

how can i compare two tables which are in two diff databases
.
supose 1 st table t1 contains
uprn description blocknumber
12 GF 1
13 gf 2

2nd table t2
uprn description blocknumber
12 GF 12
13 gf 2


table one(t1) is in school.mdb first database and

table two(t2) is in school2.mdb database

if i want to compare these two tables on "uprn" number and i want result of unmatched rows.
so please tel me how can i join these tables which r in two different data bases and compare.please give me detailed discription.


thanks

[MMcCarthy]

Firstly, I have merged both questions together. Please don't double post questions as it leads to a lot of confusion.

To compare the tables you need them both in the same database. From one of the databases you need to create a link to the table in the other database. This will allow you to query both tables. If table2 contains all the records and you need to see whats missing from table1 then ...

SELECT Table2.*
FROM Table2 LEFT JOIN Table1
ON Table2.uprn = Table1.uprn
WHERE Table1.uprn Is Null

Mary