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

Thanks Robert -- this is one of the solutions I can up with. 

Susan H. 

Here is what will work:

DELETE
FROM dbo.[threestar-rightangle]
WHERE (InvntryRcncleID
IN (SELECT InvntryRcncleID
    FROM dbo.tblRaInventoryTransactions))

The statement above delete duplicate recorts out of a temp table before an
append of new records.