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:236126 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
