Table Name: Emp
Table Name: Product
SELECT Empid, name FROM Emp e
EmpId | Name |
1 | Sagar |
2 | Raj |
3 | Mohan |
4 | Anand |
5 | Tiku |
Table Name: Product
ProductId | EmpId | ProductName |
1 | 1 | Product1 |
2 | 1 | Product2 |
3 | 2 | Product3 |
4 | 3 | Product4 |
5 | 5 | Product5 |
SELECT Empid, name FROM Emp e
WHERE NOT EXISTS
(
SELECT * FROM Product AS p WHERE p.empid = e.empid
)
No comments:
Post a Comment