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 | Fausto | Herrera | Roi_4 | herrera.fausto@myoffice.com | 8 | Sevilla | 123456789 | ver | gotas | 4 | View Edit Remove | ||||||
3 | Herrera | Fausto | Roi_4 | faustoherrera@outlook.com | 7 | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 6 | View Edit Remove | |||
4 | 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 |