Join

A relational operator that combines two relations (streams or tables) using a join condition, giving a “wider” relation. Joins include inner join, outer join, natural join and cross join.

For more information see the JOIN clause topic in the SQL Reference Guide.