n00b0101
asked on
Possible to write a query that joins data from sql db and mysql db?
Kinda think I know the answer, but, you never know until you ask...
Is it possible to write a query that will join data from a mysql table to data in a sql table? MySQL table contains Id | Code, and MSSQL table contains Code | Name. I'd like to write something kinda like this:
SELECT * FROM mysqltable, mssqltable
LEFT JOIN mssqltable
ON mysqltable.Code = mssqltable.Code
Pipe dream?
Is it possible to write a query that will join data from a mysql table to data in a sql table? MySQL table contains Id | Code, and MSSQL table contains Code | Name. I'd like to write something kinda like this:
SELECT * FROM mysqltable, mssqltable
LEFT JOIN mssqltable
ON mysqltable.Code = mssqltable.Code
Pipe dream?
http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.