Select Query
select distinct c.name, c.cust_no, s.salesman_no, s.salesman_name from 
customer_t5 c , order_t5 o , sales_mans_t5 s
where s.city=('bombay') and c.city=('rajsamand');


Output
NAME       CUST_N SALESM SALESMAN_NAME
---------- ------ ------ --------------------
pratik     001    s00004 ashish
aman       002    s00004 ashish


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