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