Subject | Can SQL be used in two DBs |
---|---|
Author | Carlos Ortiz Quiros |
Post date | 2005-09-29T18:35:48Z |
Hi you all
I wonder if I could use two databases, one named
db1.fdb and the other db2.fdb. On db1 I have table1
with fields field1 as int, field2 as varchar(200) and
the same goes for db2.
Question is:
Could I write a JOIN SQL to see which records are in
one table that are not in the other
Is it possible?
Carlos Adolfo Ortiz Q
carlosaortiz@...
______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
I wonder if I could use two databases, one named
db1.fdb and the other db2.fdb. On db1 I have table1
with fields field1 as int, field2 as varchar(200) and
the same goes for db2.
Question is:
Could I write a JOIN SQL to see which records are in
one table that are not in the other
Is it possible?
Carlos Adolfo Ortiz Q
carlosaortiz@...
______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/