PDOCrud Inner Join between tables

SQL INNER JOIN returns all rows from tables where the key record of one table is equal to the key records of another table. You can easily perform the INNER JOIN operation using pdcrud, all you need to do is specify the join table name and the join condition between two tables. Below examples shows inner join between user table and usermeta table that has matching column 'user_id'. It will select all records having matching user_id from both of these tables. During select/insert/update operation, data from both tables will be shown for inner join operation.

  
                            $pdocrud = new PDOCrud();
                            /**
                            * Add join between tables, supported join condition are "INNER JOIN" & "LEFT JOIN"
                            * @param   string  $joinTableName                             name of table to be joined
                            * @param   string  $joinCondition                             join condition e.g. 
                            * @param   string  $joinType                                  type of join (Inner or left join)-default is inner join
                            * return   object                                             Object of class
                            */
                            $pdocrud->colRename("meta_key", "Meta Key Info");
                            $pdocrud->joinTable("user_meta", "users.user_id = user_meta.user_id", "INNER JOIN");
                            $pdocrud->crudTableCol(array("first_name","last_name","meta_key"));
                            echo $pdocrud->dbTable("users")->render();

#	User id	First name	Last name	Meta Key Info	Actions
1	26	Jon	Snow	Total Experience1
2	26	Jon	Snow	Total Experience2
3	26	Jon	Snow	Total Experience3
4	26	Jon	Snow	Total Experience4
5	26	Jon	Snow	Total Experience5
6	26	Jon	Snow	Total Experience6
7	26	Jon	Snow	Total Experience7
8	26	Jon	Snow	Total Experience8
9	31	Dev	Smith	k4
10	31	Dev	Smith	k5
#	User id	First name	Last name	Meta Key Info	Actions

PDOCrud Inner Join between tables

Users