Subject | SQL Update and Delete |
---|---|
Author | Antonio Mejia |
Post date | 2004-10-12T23:51:42Z |
Hi,
I would like to see this kind of SQL syntax for Updates and Deletes
like in M$ SQL Server:
DELETE T
FROM Table1 K
JOIN Table2 T
ON K.KeyField = T.KeyField
WHERE T.FieldX = Value
UPDATE K SET
Field = T.Field2
FROM Table1 K
JOIN Table2 T
ON K.KeyField = T.KeyField
WHERE T.FieldX = Value
This is one of the few features I like for M$ SQL Server besides
derivated tables.
I would also like to have all the UDFs incorporated like native
functions!.
Cheers,
I would like to see this kind of SQL syntax for Updates and Deletes
like in M$ SQL Server:
DELETE T
FROM Table1 K
JOIN Table2 T
ON K.KeyField = T.KeyField
WHERE T.FieldX = Value
UPDATE K SET
Field = T.Field2
FROM Table1 K
JOIN Table2 T
ON K.KeyField = T.KeyField
WHERE T.FieldX = Value
This is one of the few features I like for M$ SQL Server besides
derivated tables.
I would also like to have all the UDFs incorporated like native
functions!.
Cheers,