Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2004-02-18 : 13:54:41
|
I've got an orphaned mysql app that I'm trying to bring into the fold. I don't have the time to rebuild the entire app, but I need to get some integration going.If I've got a table "items" on mysql, with an integer column that is logically a relationship to a "users" table on MS SQL, is there any way to write a query that does a join against the two databases? That is, something likeselect mysql.db.items.name,mssql.db.users.last_login from mysql.db.items join mssql.db.userson mysql.db.items.i_users=mssql.db.users.user_id I realize this is a hopelessly naive question, and I'm clueless enough that I'm not even getting effective google searches out of it. So apologies in advance if it's either a FAQ or a *really* stupid question.Thanks-b |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-02-18 : 14:11:04
|
| From what I have read, I believe you can only use OPENQUERY to execute calls against MySQL. |
 |
|
|
|
|
|
Can I join against mysql?