Page 96 - CITS - Computer Software Application -TT
P. 96

COMPUTER SOFTWARE APPLICATION - CITS





























           Syntax
           SELECT columns
           FROM table1

           LEFT JOIN table2 ON table1.column = table2.column;
           3  RIGHT JOIN (RIGHT OUTER JOIN)
              •  Returns all rows from the right table and the matched rows from the left table.
              •  If there is no match in the left table, NULL values are included for the columns from the left table
























           Syntax

           SELECT columns
           FROM table1
           RIGHT JOIN table2 ON table1.column = table2.column;
           4  FULL JOIN (FULL OUTER JOIN)

              •  Returns all rows when there is a match in either the left or the right table.
              •  If there is no match in one of the tables, NULL values are included for the columns from the table without a
                 match.








                                                           83

                              CITS : IT&ITES - Computer software application - Lesson 18 - 36
   91   92   93   94   95   96   97   98   99   100   101