Link to home
Start Free TrialLog in
Avatar of 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?
Avatar of chapmandew
Flag of United States of America image

Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial