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

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