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
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