Wednesday, July 29, 2015

SQL tutorial - lesson 9 - right join

Right join displays all the rows from the right side table along with the matching rows from the left side table.If there are no matching rows on the left side table it will display null.

Syntax:

Select "column name" from "table 1" Right join "table 2" on table1.coulmn =table2.column 




Note: please do not use ( " ) when you are trying to practice as I used them so that you can understand

No comments:

Post a Comment