Query:
Output:
SELECT * FROM sales_mans_t5 s WHERE s.salesman_name like 'a%' and EXISTS (SELECT * FROM order_t5 o WHERE o.salesman_no = s.salesman_no);
Output:
SALESM SALESMAN_NAME ADDRESS CITY STATE PINCODE SAL_AMT ------ ------------- --------- ----- ------ --------- -------- s00004 ashish A/5 jahu bombay Mah 400044 7000