DEFINITIONS
Definitions More Info.
Definition ID
889
Title
SQL
Category
NOTES
Definition
DELETE with join
Definition Description
https://stackoverflow.com/questions/16481379/how-to-delete-using-inner-join-with-sql-server
DELETE L
FROM dbr.DBA_LostInvoices L
INNER JOIN dbr.DBA_CDClog D ON REPLACE(REPLACE(L.RowGuid,'''',''),',','') =D.RowGuid
WHERE D.Operation='I'
AND L.[Status]<>D.[Status]
RecordBy
cunay
Record Date
26-09-2018 12:28:51
Düzenle
Kopyala
Sil