CBSE Class 12 Informatics Practices Question 89 of 91

JOINS and SET Operations — Question 25

Back to all questions
25
Question

Question 25

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

Table : Member

EmpIdNamePayDivno
1001Shankhya3400010
1003Ridhima3200050
1002Sunish4500020

Table : Division

DivnoDivnameLocation
10MediaTF02
20DanceFF02
30ProductionSF01
Answer
SELECT Divno 
FROM Division NATURAL JOIN Member;
Output
+-------+
| Divno |
+-------+
|    10 |
|    20 |
+-------+