What ever you have written is a JOIN clause that is used to combine rows from two or more tables, based on a related column between them.
Including outer join or left join depends on the table structure and the requirement to pull data from those tables.
IF you are looking for what is left join ,
Left join returns everything from the left table and the matching records from the right table and if there is no match in right table the result is null for the right table
Let us know what are you looking for
solved Not sure on Left Join, Outer Join, Unions or Minus? [closed]