Use of Join Clause in SQL
#microsoft #sqlserver #join

A join clause in SQL – corresponding to a join operation in relational algebra combines columns from one or more tables into a new table. Informally, a join stitches two tables and puts on the same row records with matching fields on the join condition.