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.
|