Deleting Rows from related tables in MySQL 3.2.3

2004-01-21 Thread 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? My guess is that the SELECT is considered a subquery, but how else do you get the

Re: Deleting Rows from related tables in MySQL 3.2.3

2004-01-21 Thread Roger Baklund
* 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