[dba-SQLServer] another nudge on that DELETE, OUTER JOIN quirk

MartyConnelly martyconnelly at shaw.ca
Sun May 7 14:36:01 CDT 2006

 Are you specifying which table to delete from

DELETE DISTINCTROW Original_Table.* FROM  Original_Table LEFT JOIN ...
DELETE  Original_Table.* FROM  Original_Table LEFT JOIN ...

Susan Harkins wrote:

>I've been experimenting a bit with the DELETE on an OUTER JOIN, and so far,
>I've not been able to run a single DELETE on any query that contains an
>OUTER JOIN -- I understand the null ability business, but I think what all
>that technique mumbo jumbo really means is, you can't use DELETE with an
>OUTER JOIN -- anyone know for sure about this? 
>Susan H. 
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com

Marty Connelly
Victoria, B.C.

More information about the dba-SQLServer mailing list