Thanks rudy, I have gone with the two deletes. Not elegant but functional. A suggestion was made in a subsequent post that might achieve two deletes at the same time but Im not after that. Its a case of checkingot see if the address exists in either of the tables (not in both)and then delete from the relevant table. Oh and to top things off, my &death doesnt work either.....bugger Regards Adrian Fischer -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of rudy Sent: Sunday, 6 January 2002 5:29 PM To: thelist at lists.evolt.org Subject: Re: [thelist] MySql - checking two tables at once. > DELETE FROM tblAdvise tblEmails WHERE hi adrian i think you have to issue two delete stements, one for each table rudy -- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !