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

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 "sele