Select Query
SELECT * FROM sales_mans_t5 s WHERE NOT EXISTS (SELECT * FROM order_t5o WHERE s.salesman_no=o.salesman_no);
Output
no rows selected
SELECT * FROM sales_mans_t5 s WHERE NOT EXISTS (SELECT * FROM order_t5o WHERE s.salesman_no=o.salesman_no);
no rows selected
Copyright © All Notes on BCA