Select Query

select p.prod_no, s.qty_order   from
product p, sales_order_t5 s  where p.prod_no=s.product_no;

Output
PROD_N  QTY_ORDER
------ ----------
0001            4
0002            2
0003            2
0004           10

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