Types of JOIN
Inner JOIN
A.Customer = B.Employee
Left Outer Join
A.Customer = B.Employee
Right Outer Join
A.Customer = B.Employee
Full uter Join
A.Customer = B.Employee
Working with duplicates
Left JOIN
Last updated
Inner JOIN A.Customer = B.Employee
Left Outer Join A.Customer = B.Employee
Right Outer Join A.Customer = B.Employee
Full uter Join A.Customer = B.Employee
Last updated