Select Query
select so.sales_order_no, p.description 
from sales_order_t5 so join product_t5 p on p.prod_no=so.product_no;

Output
SALES_ DESCRIPTION
------ ------------
o00001 xxx
o00002 xxx
o00003 yyy
o00004 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