I am not sure of your data representation and questions since you have two questions for "LEFT".
Here is the syntax and diagram for the (LEFT, RIGHT and INNER) which is the top three illustrations
Assuming Table A is the first table and Table B is the second table for Left Outer Join:
SELECT * FROM TableA
LEFT OUTER JOIN TableB ON TableB.ID = TableA.ID
Basically, Left Join is get everything from the first table (Table A) and any matches from the second table (Table B). Right Join is get everything from the second table (Table B) and any matches from the first table. Inner Join is to return only matches.
Usually, Left Join and Inner Join are used more frequently than Right Join.