two databases

[chaitanyajakhad]

Hi,
If I have two tables in two diffrent databases, can I use joine query to access the table

Regards,

Chaitanya

[stolzyboy]

select data from database1.table1, database2.table2 WHERE...;

[DeltaRho2K]

You would have to have the same connection username and password for the two databases as well.