retrieve data from different databases 1

[varakal]

I need to join two tables from different databases.
$src->prepare($sql) would execute the sql statement, but my doubt is how to address the tables from different databases in the sql statement.
Thanks.

 

[siberian]

You can not join across databases in generic SQL, joins are for a single tablespace only.

Now, your specific RDMS may have some cross table join feature (oracle can do this in some cases) but generally this is not the case.

 

[varakal]

I am using MySQL and it is supporting join feature across different databases. I could able to do it in MySQL. So I need to know if I can do it in perl.

 

[siberian]

I do not beleive DB supports this cross database join feature since each DBI connects to a specific database.

Its not an SQL standard so DBI can not really standardize on it. I also see nothing regarding it in the DBD::mysql driver man page.

 

[varakal]

This is what I need to know.. anyway.. I started doing the join manually.. Thank you.