We have a Vision 4 database with an ODBC driver (AccuCobol), and then I have a MySQL database that needs to be related to the Vision 4 DB. I need to be able to do a query something like this; (pseudo-code)
SELECT a.btn, a.custName, b.agingStatus FROM vision4.tblSubs a, mysql.tblSubscriber b WHERE a.btn = b.btn AND b.agingStatus <> NULL I am trying to do this without importing/reformatting/repurposing data from the Vision 4 DB. It would be preferred to have "live data" from both. If I do imports from the Vision 4 DB into the MySQL schema periodically (multiple times per day) the information is less than "live". Any thoughts? Thanks! Jay --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
