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 | Fixter | Andy | x101 | afixter@classicmodelcars.com | 7 | 1088 | Sales Rep | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 5 | View Edit Remove | |
2 | Marsh | Peter | x102 | pmarsh@classicmodelcars.com | 6 | 1088 | Sales Rep | Sydney | +61 2 9264 2451 | 5-11 Wentworth Avenue | Floor #2 | Australia | NSW 2010 | APAC | 3 | View Edit Remove | |
3 | King | Tom | x103 | tking@classicmodelcars.com | 7 | 1089 | Sales Rep | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 5 | View Edit Remove | |
4 | Gerard | Martinm | x2312 | mgerard@classicmodelcars.com | 4 | 1102 | Sales Rep | Paris | +33 14 723 4404 | 43 Rue Jouffroy D'abbans | France | 75017 | EMEA | 6 | View Edit Remove | ||
5 | azert | berthe | totot.fr | berthe.azert@myoffice.com | 1 | ' | San Francisco | +1 650 219 4782 | 100 Market Street | Suite 300 | CA | USA | 94080 | NA | 4 | View Edit Remove | |
6 | 3432432kjkjkjk | pippo.dadmkmkma | 98898989 | pippo.dada.3432432@myoffice.com | 6 | Sydney | +61 2 9264 2451 | 5-11 Wentworth Avenue | Floor #2 | Australia | NSW 2010 | APAC | 3 | View Edit Remove | |||
7 | 8 | Sevilla | 123456789 | ver | gotas | 0 | View Edit Remove | ||||||||||
8 | Fausto | Herrera | Roi_4 | herrera.fausto@myoffice.com | 8 | Sevilla | 123456789 | ver | gotas | 0 | View Edit Remove | ||||||
9 | Herrera | Fausto | Roi_4 | faustoherrera@outlook.com | 7 | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 5 | View Edit Remove | |||
10 | asdasd | asdasd | asdasd | Meerasdasd.2007@Yahoo.com | 7 | asdasdasd | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | UK | EC2N 1HN | EMEA | 5 | View Edit Remove |