Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sun, Nov 12 2006 1:13 PM	Permanent Link
"Mirco"	It is possible to join 2 table one from Remote Server and other from local PC? DBIsam 4 thanks!
Sun, Nov 12 2006 1:33 PM	Permanent Link
"Ralf Mimoun"	Mirco wrote: > It is possible to join 2 table one from Remote Server and other from > local PC? No. Ralf
Mon, Nov 13 2006 4:32 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Mirco Ralf almost got it right The answer is yes (sometimes) but its not easy, and it probably won't do what you want anyway If the Remote Server is on a LAN: You need to know the path to both the local and remote file and then simply code the two tables fully qualified into the sql If the remote server is on a WAN the best you can do is stream one of the tables to where the other is. If one of the tables is only small it might be possible but with a reasonably sized table the time taken to stream means you might as well use tables. Roy Lambert