If the dbs are on the same server, and the connected user has the correct rights, you would just need to qualify the table names with the db names... SELECT .... FROM db1.table1 INNER JOIN db2.table2 ON ....
I believe the above will work for MySQL...in MS-SQL, you will have to also include the table owner... SELECT .... FROM db1.dbo.table1 INNER JOIN db2.dbo.table2 ON .... or just SELECT .... FROM db1..table1 INNER JOIN db2..table2 ON .... I don't think you have to include the table owner in MySQL. On 3/24/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > I'm building a site for a realtor who will be displaying real estate > listings on their website. Now, my company has an agreement with the local > MLS company that we get a nightly dump of their records so that we can have > a local copy of every listing in the middle Tennessee area. > > I am storing just the MLS number in a table for this realtor's website, then > looping over the OTHER database to get the detailed information. I'm fine > with that in most cases but now I'm working on a search function which needs > to able to access both the foreign key MLS number in the realtor database > AND the price and location information stored in the MLS database. > > So is it possible to join two totally different tables together somehow? > They are on the same server and both are under my control if that helps. > > I'm using mySQL 4.01 on a Linux machine if that's important. > > I suspect the answer to this will be no, but I needed to ask anyway. > > <!----------------//------ > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236135 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
