Left Join: Returns all rows from the left table and the matched rows from the right table.
If there is no match, the result is NULL on the side of the right table.
In SQL, the syntax for a left join would look like this:
Get instant updates and alerts directly from our site.
Install this app on your device for quick access right from your home screen.