Bruce Momjian wrote:
It's been agreed that the keyword should
> be USING, to avoid anything as confusing as DELETE FROM a FROM b.
FYI,
MSSQL says
DELETE [FROM] {tablename} [FROM {<tablesource> [, ...] ] [WHERE <condition>]
Note that the first FROM is optional (as in Oracle), we can have
DELETE a FROM b
The USING would be in place of the mandatory FROM in MSSQL. And why use
a different keyword for the same thing in DELETE and UPDATE?
DELETE a FROM b
UPDATE a FROM b
DELETE FROM a USING b
Regards,
Andreas