At 11:05 AM -0500 9/27/01, Chris Johnson wrote:
>MySQL does not yet have the ability to do join operations during delete or
>update processing. So, although you can do what you ask in Oracle, Sybase,
>and others, you cannot do it in MySQL. Sorry. It's one of the biggest
>weaknesses in my view.
This will work in MySQL 4.
>----- Original Message -----
>From: "Jay Paulson" <jpaulson@stripped>
>Sent: Thursday, September 27, 2001 10:54 AM
>Subject: Delete query question
>Can you do something like this?
>delete from table1, table2 where table1.id=1 and table2.id=4;
Paul DuBois, paul@stripped