DEFINITIONS

Definitions More Info.
Definition ID889
TitleSQL
CategoryNOTES
DefinitionDELETE with join
Definition Descriptionhttps://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]
RecordBycunay
Record Date26-09-2018 12:28:51
Düzenle
Kopyala
Sil