Tag: SQL Join

Introduction In this tutorial I will show CodeIgniter full outer join example. I will build full outer join or full join query using MySQL’s UNION for fetching data from multiple tables. The purpose of a join is to combine the data across tables. A join is actually performed by the where clause which combines the…

Introduction Here I am going to show CodeIgniter right outer join example. I will use CodeIgniter’s Query Builder Class to build right outer or right join queries for fetching data from multiple tables. The purpose of a join is to combine the data across tables. A join is actually performed by the where clause which…

Introduction Here I am going to show CodeIgniter left outer join example. I will use CodeIgniter’s Query Builder Class to build left outer or left join queries for fetching data from multiple tables. The purpose of a join is to combine the data across tables. A join is actually performed by the where clause which…

Introduction In this tutorial I will show you CodeIgniter join example. I will use CodeIgniter’s Query Builder Class to build join queries for fetching data from multiple tables. The SQL Join clause is used to combine records together from two or more tables in a database. A Join locates related column values in two or…