Write a SQL query to display all the divnos in Member table but not in the Division.

Q. Write a SQL query to display all the divnos in Member table but not in the Division.

Table: Member

Empld	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

Answer :-

Select  Divno from member where ( select Divno from Division ) <> Divno ;