SQL;

JOIN IN SQL

JOIN states to combine something. In SQL, it means that 'combination of one or two tables'

• Inner Join
• Full outer Join
• Left Join
• Outer Join

1. Inner Join: It returns all rows in a table when there is at least one comparesion in both the tables.
2. Full Join: It return all rows in a table when there is a match in one of the tables available.
3. Left Join: It return all rows from the left table and then compare rows from the right table.
4. Right Join: It return all rows from the right table and then compared rows from the left table.

After Joining the table we get:

SELECT emp_id,e_name,e_salary   
FROM Employee e, week off o  
WHERE e.Emp_id =o.shift_id;