This is how I did it:
SELECT db1t1.listing_id, db1t1.listing_mlsnumber,db1t1.listing_type,
db2t2.pLisPric
FROM db1.table1 db1t1
INNER JOIN db2.t2 db2t2
ON db2t2.pMlsNum = db1t1.listing_mlsnumber
<!----------------//------
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--------------//--------->
-----Original Message-----
From: Srinivasa Teja Palla [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 6:53 AM
To: CF-Talk
Subject: Re: Joining two different databases?
I have a question.. Even if you can join on those two databases using fully
qualified paths, how do u create a dsn that you will have to use to execute
teh query?
what does it use for the db? will it work just if you point the dsn to
either of the databases and use full paths?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236235
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
