Write a SQL query to display common divnos from both the tables.

Q. Write a SQL query to display common divnos from both the tables.

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 member.Divno , Division.Divno from member , Division where  member.Divno = Division.Divno;