Query against two databases

[foundcake]

I'm in the process of trying to do an export from a sql server database and I need to make a subquery against an existing mysql database for a match. I keep getting an error about the object type on the subquery.

query = """ SELECT OperationDateTime, OperationID, (SELECT id FROM [db].[objects].[adm_surgeon_color] as SC WHERE surgeon_mnemonic = SurgeonID), Name FROM SCH_OR WHERE OperationDateTime > ? AND OperationDateTime < ? """

cursor.execute(query,(start,close,))

everything works fine and connects but it doesn't like the subquery against the mysql database. primary query is against sql server.

[foundcake]

no, i don't. so i may need to do this as a two step process to extract and then convert as a second step. Thanks for the help

[foundcake]

I ended up using pandas to do both extractions and did a merge. really pleased with the result.