The best replacement for outer join is inner join.

The best alternatives to outer join are rated as following:
★★★★★  inner join
★★★★  left join
★★★  union
★★  full outer join
★★  subquery
★  right outer join
★  union all
★  cross join
★  not exists
★  inner join performance
★  natural join
★  not in
★  outer apply
★  left outer join
★  exists
  clause
  inner join sql
  join
  where clause
  except
  full join
  not exists oracle
  left inner join
  minus
  inner join oracle

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

Other search terms related to outer join and their ratings are:
★★★★★ 3 tables
★★★★ multiple tables
★★ in clause
★★ inner join
★★ duplicates
★ three tables
★ on clause
using outer join
You have in mind a companion for outer join and it is not yet here? Propose!



Google Trends

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