In Teradata SQL, a join is a SELECT operation that allows columns and rows to be combined from two or more tables to produce a result. Join types restricted by Teradata DWM are inner join, outer join, merge join, product join, and all joins. For more information, see all joins, exclusion join, inner join, merge join, nested join, and RowId join.