Query on 3 db

[truiz]

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.

[truiz]

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?