DBMS | OUTER JOIN | Exp - 8

OUTER JOIN

The SQL OUTER JOIN returns all rows from both the participating tables which satisfy the join condition along with rows which do not satisfy the join condition. The SQL OUTER JOIN operator (+) is used only on one side of the join condition only.

The subtypes of SQL OUTER JOIN

• LEFT OUTER JOIN or LEFT JOIN
• RIGHT OUTER JOIN or RIGHT JOIN
• FULL OUTER JOIN

Problem Statement

SELECT *
FROM table1, table2
WHERE conditions [+]

For more info visit w3resources

Problem Statement

Company want number of employee details who are working in Production, Quality, HR and Account department Indore branch and holds 'A' Grade.

File: Download here