Seeing as how you are really good with this stuff. I've written the below
query and it finds the invoiceitems and invoices that I want to delete. Can
you modify this so it deletes both the invoice items and invoices that it's
selecting? I have no fear doing a select but when it comes to delete I tend
to be a little bit more than careful and I'm not comfortable with this one.
Any help would be appreciated.
Geo.
select itemID, description, invoiceid from invoiceitems
where (select type from invoices where
invoiceitems.invoiceID=invoices.invoiceID
and invoiceitems.paymentid is NULL)='void'
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart