truiz Posted May 23, 2007 Share Posted May 23, 2007 Hi, Please can you tell me how can I do this?I'm working with Java 1.6, PostreSQL and I am in trouble. String query = "SELECT * FROM ((table1 JOIN " + "table2 ON table1.pk = table2.pk)JOIN table3" + " ON table3.pk = table1.pk)"; where I use 3 databases separated and the tables are assigned as follow:table1 and table3 are on DB1,table2 is on DB2,table4 is on DB3Thanks. Link to comment Share on other sites More sharing options...
truiz Posted May 24, 2007 Author Share Posted May 24, 2007 I hope you can help me!!I've tried to merge data from resultset, but it's very very hard for me select data from 4 table through only one JTable.Have you got an alternative idea? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.