These topics describe joins of tables and views.
For an outer join case study that shows how to write correct outer joins that provide the results you intend, see Outer Join Case Study.
For information on the algorithms used by the Optimizer to perform these joins, see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.