[thelist] MySql - checking two tables at once.

[Adrian Fischer]

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 !