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
   175   176   177   178   179   180   181   182   183   184   185