troubleshooting Question

Possible to write a query that joins data from sql db and mysql db?

Avatar of n00b0101
n00b0101 asked on
Microsoft SQL Server 2008MySQL Server
2 Comments1 Solution225 ViewsLast Modified:
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?
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros