CBSE · 083Class XII · 2022Section A1 mark
Question 6a
7 June 2022 · Computer Science (083)
Table: DOCTOR
| DNO | DNAME | FEES |
|---|---|---|
| D1 | AMITABH | 1500 |
| D2 | ANIKET | 1000 |
| D3 | NIKHIL | 1500 |
| D4 | ANJANA | 1500 |
Table: PATIENT
| PNO | PNAME | ADMDATE | DNO |
|---|---|---|---|
| P1 | NOOR | 2021-12-25 | D1 |
| P2 | ANNIE | 2021-11-20 | D2 |
| P3 | PRAKASH | 2020-12-10 | NULL |
| P4 | HARMEET | 2019-12-20 | D1 |
Write the output of the SQL query: SELECT DNAME, PNAME FROM DOCTOR NATURAL JOIN PATIENT;
Answer
| DNAME | PNAME |
|---|---|
| AMITABH | NOOR |
| ANIKET | ANNIE |
| AMITABH | HARMEET |
Explanation
Performs a natural join on the common column DNO and selects Doctor and Patient names.