SQL Outer-Join Clause

MAKE FULL WEB APPLICATION WITH JUST SQL KNOWLEDGE? CLICK HERE

Outer join is essential to display all the records from one table and some from another it is called outer join. In inner join or equal join a matching common value is checked in both the tables for equality. In outer join, it picks all the records from one table and take only the matching records from another table, displaying NULL from non-matching values. The outer join is only possible between two tables. There are two types of outer join namely left and right.

EXAMPLE#I :-

We have a table called Name with two fields (Grade and name).
It contains the following data :-

We have a second table called Percentage with three fields (Grade, Marks, and percentage).
It contains the following data :-

If we ran the SQL statement below :-

Our RESULT set would look like this :-

If you don't find what you are looking for. Please click here to submit your query, our experts will reply soon.