IBM-DB2:join 2 tables from 2 diff.databa

W

wxdqz

New Member
I have 2 tables in 2 different databases, on the same server.
table1 = clients(idcli,cliname,...) in database1
table2 = projects(idpro,idcli,proname,...) in database2

I would like to run the following SQL-statament

SELECT proname,cliname FROM database1.clients,database2.projects WHERE
clients.idcli=projects.idcli

The problem is that when I am in the first database I can't contemporary see the table in the second database.

Can anybody help me?
Thanks in advance.
Girolamo
 
You must log in or register to reply here.
Back
Top