Navneet Kakkar
|
Posted: 01/20/2004, 10:49 PM |
|
Option of choosing a join query on multiple connection.
i.e. selecting fields from two tables which are from two different
connections.
is this possible.
--
Thanks
luv
Navneet
aquananu@yahoo.com
+919811153443
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date: 1/19/2004
|
|
|
Edd
Posts: 547
|
Posted: 01/21/2004, 4:47 AM |
|
Navneet,
Depending upon the Database you can do such a thing BUT unless they reside on the same server - DON'T - it adds a level of complexity that will give you all sorts problems. MS SQL allows for this but it is not recommended for Transaction based systems such as web sites.
Try replication with cycled triggers - much more robust in the long run.
Keep it simple.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|