delete query ?

Hi,
Is this a valid SQL Server query :
DELETE FROM D FROM D WHERE LEFT JOIN H ON H.key=D.key WHERE H.key IS NULL
Please advise.
Thanks,
SamIt is not valid SQL. Joins are only allowed in the FROM clause.

If you'd bothered to mention what you are trying to do it might have been possible to give some legal SQL that does it. :rolleyes:

Dag|||Your syntax is almost correct except for one too many FROMs and WHEREs:

DELETE D FROM D LEFT JOIN H ON D.key=H.key WHERE H.key IS NULL

delete query ?

Hi,
Is this a valid SQL Server query :
DELETE FROM D FROM D WHERE LEFT JOIN H ON H.key=D:key WHERE H.key IS NULL
Please advise.
Thanks,
SamPlease ignore the above query, this is invalid, as I have type as 'd:key'. Please see my next post to this.