You can query multiple databases as long as you have permissions on both. In
mySQL you prepend the table name with the database name like so:
SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type,
d2_t4.pLisPric
FROM databasename_01.table_01 d1_t1
INNER JOIN databasename_02.table_04 d2_t4
ON d2_t4.pMlsNum = d1_t1.listing_mlsnumber
In Oracle, you can also create "link" tables to other databases. I'm not sure
how this is done, but I have used the results once our DBA's have set it up.
I would also imagine that your joining could be done in a query of a query
after the two tables where queried from.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
---------
| 1 | |
--------- Binary Soduko
| | |
---------
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241240
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
