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