All Notes on BCA

select s.product_no, p.description, p.unit_price, p.qty_on_hand 
from product_t5 p JOIN sales_order_t5 s ON p.prod_no= s.product_no 
where s.qty_disp=0;

PRODUC DESCRIPTION  UNIT_PRICE QTY_ON_HAND
------ ------------ ---------- -----------
0004   zzz          2300           2