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...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.