LEFT OUTER JOIN in SQLite
Actually, the LEFT OUTER JOIN is the extension of the INNER JOIN and there are LEFT, RIGHT, and FULL Outer Join, whereas SQLite only supports the LEFT OUTER JOIN.
Left Outer Join returns all the rows from the left-side table that has specified in the ON condition and it displays only the rows that met the join condition from the other table.
Syntax:
SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;
Example of LEFT OUTER JOIN
SELECT t.name, t.salary, d.dept
FROM Teachers as t
LEFT OUTER JOIN department as d
on t.Id = d.emp_id;
Output:
Explanation:In the above Query, with the help of LEFT OUTER JOIN we have fetched the respective columns fields data here we use id from both table as a Matching or same column. It also return all the data from the left table i.e, Teachers Table.
SQLite Joins
SQLite is a server-less database engine and it is written in C programming language. It is developed by D. Richard Hipp in the year 2000. The main motive for developing SQLite is to overcome the use of complex database engines like MySQL etc. It has become one of the most popularly used database engines used in Television, Mobile Phones, web browsers, and many more. It is written simply so that it can be embedded into other applications.
In this article we will learn about the Joins in SQLite, and how it works, and also along with that, we will be looking at different types of joins in SQLite in a detailed and understandable way with examples.