Informatics Practices

Write a SQL query to display all the divnos in Member table but not in the Division table.
Table : Member
EmpId Name Pay Divno
1001 Shankhya 34000 10
1003 Ridhima 32000 50
1002 Sunish 45000 20
Table : Division
Divno Divname Location
10 Media TF02
20 Dance FF02
30 Production SF01

EmpId	Name	Pay	Divno
1001	Shankhya	34000	10
1003	Ridhima	32000	50
1002	Sunish	45000	20

3 Likes

SELECT m.Divno 
FROM Member m 
LEFT JOIN Division d ON m.Divno = d.Divno 
WHERE d.Divno IS NULL;

+-------+
| Divno |
+-------+
|    50 |
+-------+

Answered By

1 Like