Table of Contents

Joins

Cross Join

• Cartesian Product
• Rows rendered: no of rows in A * no of rows in B
• Columns rendered: no of columns in A + no of columns in B

Inner Join

• contains common column twice
• to skip the common column, use the keyword natural

Theta Join

• with a condition
• using on keyword

Equi Join

theta join with '=' operator

Outer Join

Left Outer Join