Hi

This code should do your job:

alter table salesOrders

add OrderMatched varchar(3) null

update salesOrders

set OrderMatched = 'yes'

from salesOrders s join ProductList p on s.ProductID = p.ProductID

update salesOrders

set OrderMatched = 'no'

where OrderMatched is null