RE: Join table from two diff. DB server?

First you should be able to access both tables from the server where you are constructing the join Second do a simple Select .....From local-table a, remote-table b but user the Informis conventions to name a remote table i.e. databasename@servername:ownere.table if this es too much for the query you can previously create a synonym Also can put every thing in a view > -----Original Message----- > From: Wira Soedarmono [SMTP:wsoedarm@Vorlon.odc.net] > Sent: Wednesday, June 16, 1999 6:56 PM > To: informix-list@iiug.org > Subject: Join table from two diff. DB server? > > Hi all, I am wondering if I can join table from two diff. server but the > remote server allows > only read access. How can I join the table in the remote site? Is there > anyway to join those tables? > For examples; > > If I have table in the local DB server name personal_data and I have table > in the remote DB > server name credit_card_info table and both are link using the SSN number. > How can I join those > two tables on the remote site if I have only read access permission? > Please advice me! > > I am using Informix Server 9.x on both DB Server and UNIX Solaris is my > OS. > > Thank you ver much. > > > Wira Soedarmono