Hello guys,
I created two database in derby:
DB1 with one table Customers and its columns id,name,last
And
DB2 with one table Purchases anf its colums CustID, total
I would like to makes queries from data in both of these database.
I tried
SELECT C.name, C.last, U.Total FROM
DB1.Customers C INNER JOIN DB2.Purchases U ON C.id=U.CustID;
Can anybody help me...