Wednesday, July 29, 2015

SQL tutorial - Lesson 8 - Left Join

Left join returns all the rows from the left side table along with the matching rows from the right side table. and if there is no match on the right side table it display null

syntax: select "column name" from "table1" left join "table2" on table1.coulmn =table2.column


Please look at the picture below for better understanding






When you are writing the query. do not use quotes ( " ) I used it so that you can understand the fields that I am trying to explain

No comments:

Post a Comment