SQL Session Part IV

SQL Session for Beginners: The third part of SQL Series where we will cover following topics: Under SQL Basics we will see – Inner Join, Full Join, Left Join, right Join and Self Join. The INNER JOIN keyword selects records that have matching values in both tables. The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match. The RIGHT JOIN keyword returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side, when there is no match. The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records. A Self Join is a regular join, but the table is joined with itself.