List:General Discussion« Previous MessageNext Message »
From:A Z Date:April 15 2004 11:31am
Subject:Query 2 DBs
View as plain text  

2 DBs sitting on different machines, any idea of how
to run the query?

Select a.*, b.field1 from computernam.db1.table1 a,
computername.db2.table1 b where a.fieldx = b.fieldx

where computername is host for DB.


Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now
Query 2 DBsA Z15 Apr
  • Re: Query 2 DBsMartijn Tonies15 Apr