1. What are different types of JOINS used in SQL?
2. Assume there are two SQL tables with Emp_ID,
Emp_LN, Emp_FN and Emp_Pos as fields for an Employee table, and Emp_ID, Emp_LN, Emp_FN and Emp_J_Date as fields for the JDate table.
Create SQL statements to illustrate the operations below:
1. Inner Join
2. Left Join
3. Right Join
4. Full join
The joins used in sql are : Inner join, Left join, Right join and Full outer join. The queries to perform joins on tables... View the full answer