Sqlite Join - Android, IOS

Sqlite join is used to combine two or more tables in a database. Here is the examples for understanding sqlite join.

sqlite> .schema
CREATE TABLE  EMPLOYEE(EmpId INTEGER, EmpName TEXT);
CREATE TABLE COMPANY(EmpId INTEGER, Position INTEGER,JoiningDate DATE);

Joining Two Tables:


sqlite > select EMPLOYEE.EmpName, COMPANY.Position from EMPLOYEE JOIN COMPANY;