>I can't get "delete for query not in (query)" to work. i thought a vaild query should work for "Delete For expression1" command.
>
>Thanks in advance, Chuck
Chuck,
Try
delete table1 from table1 where ID not it (select ...)
If it's not broken, fix it until it is.
My Blog