[thelist] MySql - checking two tables at once.

Adrian Fischer adrian at aussiebidder.com
Sun Jan 6 01:46:11 CST 2002

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


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


For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list