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

{ 1 comments ... read them below or add one }

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA