I have the following query which works fine in MySQL:
DELETE sb FROM stockbatches sb INNER JOIN batchestodelete btd ON sb.batch_batch = btd.batchno AND sb.batch_part = btd.batchpart
What I want to do is run this query on the MySQL table from SQL Server using an
openquery to a linked MySQL server. I cannot get the syntax right.
Can anybody help please?