SQLite Joins

In SQLite, JOIN clause is used to combine records from two or more tables in a database. It unites fields from two tables by using the common values of the both table.

There are mainly three types of Joins in SQLite:

  • SQLite INNER JOIN
  • SQLite OUTER JOIN
  • SQLite CROSS JOIN

Example:

We have two tables "STUDENT" and "DEPARTMENT".

Sqlite Joins 1

The "STUDENT" table is having the following data:

Sqlite Joins 2

The "DEPARTMENT" table is having the following data:

Sqlite Joins 3
Related Tutorial
1 SQLite Joins

2 SQLite Inner Join
3 SQLite Outer Join
4 SQLite Cross Join
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Try it
http://codeamaze.com
Contents +