|< < 3 > >|

Join

Remember Relational Algebra?

  • In Relational Algebra, the join operator combines two tables by matching values on common columns.

  • (Almost always FK/PK columns.)

Join in SQL

  • There are two ways to specify a join in SQL.

  • Start with the one that introduces less new syntax.

|< < 3 > >|