Products used on bookings that are no longer in inventory

select * from tblitemtran where ISNULL(product_code_v42 , '') <> '' AND ISNULL(product_code_v42 , '') NOT IN (
select ISNULL(product_code, '') from tblinvmas)