Subject SQL Update and Delete
Author Antonio Mejia
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,