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

Q. Write a SQL query to display all the distinct 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 DISTINCT member.Divno , DISTINCT Division.Divno from member , Division ;