select * from tableA
minus
select * from tableA_at_yourdblink
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Lane Mabbett" <lane.mabbett_at_fmr.com> wrote in message
news:tno46.150$q31.386_at_news-srv1.fmr.com...
> Greetings. How is it possible (if at all) to execute a query on two
> instances located on separate servers? I'm told it can be done but am at
a
> loss. I have two databases that should contain the exact same
information.
> However, one database has more records than the other. I need to write a
> select statement that will show what records exist in one database that do
> not exist in the other. Thanks in advance.
>
>
Received on Wed Jan 03 2001 - 10:10:34 CST
