The best replacement for left join is left outer join.

The best alternatives to left join are rated as following:
★★★★★  left outer join
★★★★  right join
★★★★  inner join
★★★  join
★  not in
★  not exists
★  inner join sql
★  subquery
  outer apply
  outer join
  cross join
  left inner join
  full join
  join performance
  subselect
  where clause
  full outer join
  inner join mysql

Your alternative for left join is not listed? Suggest!
Speaking about left join, one probably shouldn't forget about subquery.

Other search terms related to left join and their ratings are:
★★★★★ subquery
★★★★★ 3 tables
★★★★ inner join
★★★ group by
★ three tables
★ proc sql
subselect
or condition
You have in mind a companion for left join and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of left join in all years. Click on graph for more.
left join
left outer join
right join