SQL - Menampilkan data A yang Tidak ada di Data B

Contoh

select * from [192.168.90.24].[naughtypos].dbo.promotion
where promotioncode not in(select promotioncode from promotionHeader)

update [192.168.90.24].[naughtypos].dbo.promotion
set ValidTo ='1900-01-01 00:00:00.000'
where promotioncode not in(select promotioncode from promotionHeader)

sumber :

https://www.dumetschool.com/blog/Fungsi-NOT-IN-pada-SQL