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

Susan Harkins harkinsss at bellsouth.net
Sun May 7 14:48:35 CDT 2006


FROM one LEFT JOIN many 
ON one.column = many.column

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
Sent: Sunday, May 07, 2006 3:36 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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 ...
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.

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 5/5/2006

More information about the dba-SQLServer mailing list