Select Query
SELECT sod.product_no, p.description FROM sales_order_t5 sod JOIN product_t5 p ON sod.product_no = p.prod_no WHERE sod.qty_disp=0;
PRODUC DESCRIPTION ------ ------------ 0004 zzz
SELECT sod.product_no, p.description FROM sales_order_t5 sod JOIN product_t5 p ON sod.product_no = p.prod_no WHERE sod.qty_disp=0;
PRODUC DESCRIPTION ------ ------------ 0004 zzz
Copyright © All Notes on BCA