the ansi syntax for delete is delete from table where ???
You don't tell it what to delete since it will always delete whole rows.
So just remove o.* .
If you are in need of setting a field to blank you'll have to use an update, not a
delete.
Ryan
-Original Message-
From: andy
Delete from does not work with multiple tables, AFAIK..
-Szii
- Original Message -
From: andy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 2:02 AM
Subject: [PHP-DB] sql querry problem
Hi there,
I do have 2 tables. One contains an update for the other one.
, May 03, 2002 11:48 AM
To: andy
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] sql querry problem
Delete from does not work with multiple tables, AFAIK..
-Szii
- Original Message -
From: andy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 2:02 AM
Subject: [PHP-DB] sql