Q. Write a SQL query to display all the 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 ;

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post