[GENERAL] Select from different database

[Jacob Vennervald Madsen]

Hi All

Is it possible to fetch data from another database than the current?
E.g. like in Oracle I can select data from 2 different DB's like this:

select * from db1.table1 as tbl1, db2.table2 as tbl2 where tbl1.id1 =
tbl2.id2;

Jacob


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]