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

 Are you specifying which table to delete from

DELETE DISTINCTROW Original_Table.* FROM  Original_Table LEFT JOIN ...
or
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
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada