use T23V003 select * from BILL_ITEM_DETAIL where ItemName not in (select ItemName from FINISHED_ITEM_MASTER)