I need to query multiple database in a single query.
e.g.
Database d1 contains table t1 with column id
Database d2 contains table t2 with column id
I need a query like
SELECT * FROM t1, t2 WHERE t1.id = t2.id;
is this possible in
jdbc? if yes can anyone help with some samle code?
thanks,
Ashish Saraf