Query Joins

Example

join[]=joinType:tableName:leftKey:rightKey

The join clause takes 4 parameters

• joinType - can be 1 of inner, left or cross
• tableName - the table to join on
• leftkey - the table field used on the left side of the Join on clause
• rightKey - the table field used on the right side of the Join on clause

More examples

join[]=inner:posts:posts.user_id:users.id

is the same as

$model->join('posts', 'posts.user_id', '=', 'users.id', 'inner');