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

Try a Select if that works then it is a problem with an non updateable 
query.
I know Joe Celko addresses a lot of these outerjoin problems between 
different database
SQL Syntax in SQL for Smarties.


Susan Harkins wrote:

>I tried yours -- the only difference seems to be that you specified the
>non-nullable table. Using the following statement, I still got an error:
>
>DELETE Customers.*
>FROM Customers LEFT JOIN Orders
>ON Customers.CustID = Orders.CustID
>
>I'm using Express -- prehaps the two versions aren't compatiable on this
>issue?
>
>Susan H. 
>
>
> 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 ...
>
>
>_______________________________________________
>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