Joins

An SQL join clause - corresponding to a join operation in relational algebra - combines columns from one or more tables in a relational database.