search

tgparkk / notepad

1 stars 0 forks source link

mssql delete join #13

Open tgparkk opened 5 months ago

tgparkk commented 5 months ago

delete from AA from AA a left join BB b on (a.PANORAMA_ID = b.PANORAMA_ID and a.ROUTE_ID = b.ROUTE_ID) where b.PANORAMA_ID is null