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

#LastnameFirstnameExtensionEmailOfficecodeReportstoJobtitleCityPhoneAddressline1Addressline2StateCountryPostalcodeTerritoryOrdering
Actions
1FixterAndyx101afixter@classicmodelcars.com71088Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA5 View Edit Remove
2MarshPeterx102pmarsh@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC3 View Edit Remove
3KingTomx103tking@classicmodelcars.com71089Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA5 View Edit Remove
4GerardMartinmx2312mgerard@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA6 View Edit Remove
5azertberthetotot.frberthe.azert@myoffice.com1'San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA4 View Edit Remove
63432432kjkjkjkpippo.dadmkmkma98898989pippo.dada.3432432@myoffice.com6Sydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC3 View Edit Remove
78Sevilla123456789vergotas0 View Edit Remove
8FaustoHerreraRoi_4herrera.fausto@myoffice.com8Sevilla123456789vergotas0 View Edit Remove
9HerreraFaustoRoi_4faustoherrera@outlook.com7London+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA5 View Edit Remove
10asdasdasdasdasdasdMeerasdasd.2007@Yahoo.com7asdasdasdLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA5 View Edit Remove
Search