Join other table
Allows you to join other tables. Only INNER JOIN supported. Keys in all joined tables must exist and be unique
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table('employees');
$xcrud->join('officeCode','offices','officeCode'); // ... INNER JOIN offices ON employees.officeCode = offices.officeCode ...
echo $xcrud->render();
?>
Employees
| # | Lastname | Firstname | Extension | Officecode | Reportsto | Jobtitle | City | Phone | Addressline1 | Addressline2 | State | Country | Postalcode | Territory | Ordering | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 8 | Sevilla | 123456789 | ver | gotas | 4 | View Edit Remove | ||||||||||
| 2 | asdasd | asdasd | asdasd | Meerasdasd.2007@Yahoo.com | 7 | asdasdasd | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 6 | View Edit Remove |