Thank you for taking the time to reply
I am using version 4.1 as can be seen from the out put below
mysql Ver 13.5 Distrib 4.1.0-alpha, for portbld-freebsd5.1 (i386)
Also I am unsure of the syntax for what you suggest
>
>Are you aware that you are using a nested sql query which isn't available
>un
Are you aware that you are using a nested sql query which isn't available
until version 4.1?
Try splitting the delete into multiple steps 1) populate a temp table with
the id's you want to delete then 2) use the temp table data to delete the
rows.
- Original Message -
From: "tech" <[
