NOT EXISTS SQL

SELECT * FROM Orders O WHERE NOT EXISTS (SELECT Item_Code FROM product_table P WHERE O.ItemNumber = P.item_code);