Page 180 - IT-802_class_12
P. 180
Notes
We can also use RIGHT OUTER JOIN instead of RIGHT JOIN, both are the same.
Table A Table B
Example:
SELECT EmpLOyEE.Emp_iD, EmpLOyEE.SALARy, EmpLOyEE.Emp_NAmE
FROm EmpLOyEE
RiGHT JOiN EmpLOyEE_DETAiLS
ON EmpLOyEE.Emp_iD = EmpLOyEE_DETAiLS.Emp_iD;
Output:
+--------+--------+-------------+
| Emp_iD | SALARy | Emp_NAmE |
+--------+--------+-------------+
| 03 | 18000 | NEHA_DAS |
| 04 | 25000 | RADHA_SiNHA |
| 06 | 28000 | RAVi_yADAV |
+--------+--------+-------------+
1.12.4 Full Join
FULL JOIN creates the result-set by combining results of both LEFT JOIN and RIGHT JOIN. The result-set will contain all the
rows from both tables. For the rows for which there is no matching, the result-set will contain null values.
Table A Table B
178 Touchpad Information Technology-XII

