Hello,
mysql 4.1.11 on debian.
I've db1 with table1 and db2 with table2.
How can i make a join into table1 and table2?
If each table are into the same db i can write:
select a.campo1, b.campo2 FROM table1 a INNER JOIN table2 b ON
a.campo1=b.campo2;
But what about my problem?
Thank you very
Vittorio - assuming the two databases exist within the same database
server, do this:
select a.campo1, b.campo2
FROM db1.table1 a INNER JOIN db2.table2 b ON a.campo1=b.campo2;
Dan
On 7/7/06, Vittorio Zuccalà [EMAIL PROTECTED] wrote:
Hello,
mysql 4.1.11 on debian.
I've db1 with table1
