Types of JOIN

  1. Inner JOIN A.Customer = B.Employee

  2. Left Outer Join A.Customer = B.Employee

  3. Right Outer Join A.Customer = B.Employee

  4. Full uter Join A.Customer = B.Employee

Working with duplicates

Left JOIN

Last updated