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 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 much!!
--
vittorio zuccalà
Finconsumo Banca SPA
[EMAIL PROTECTED]
Tel: 011-6319464
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
