I am getting a syntax error from MySQL when executing the following
query (names substituted):
Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
WHERE Another_ID='1');
What is going wrong?
My guess is that the SELECT is considered a subquery, but how else do
you get the
* Zaxpaw
I am getting a syntax error from MySQL when executing the following
query (names substituted):
Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
WHERE Another_ID='1');
What is going wrong?
Version 3.x does not support sub-selects.
My guess is that the SELECT