Susan Harkins
harkinsss at bellsouth.net
Sun May 7 14:48:35 CDT 2006
No: DELETE 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 MartyConnelly 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 ... 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.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