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;

Output
PRODUC DESCRIPTION
------ ------------
0004   zzz

Leave a Reply

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA