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

PreviousCAST and CONVERT (Transact-SQL)NextOur first Left Outer Join

Last updated

Was this helpful?