ANLY620

Write a note on different types of JOINS used in SQL.

2. Assume you have two SQL tables with Emp_ID, Emp_LN, Emp_FN and Emp_Pos as fields for Employee table and Emp_ID, Emp_LN, Emp_FN and Emp_J_Date as fields for JDate table.

Create SQL statements to illustrate the operations below:

1. Inner Join

2. Left Join

3. Right Join

4. Full join