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
1BonduraaaaaaaGerard2x540gbondur@classicmodelcars.com31050Sale Manager (EMEA)NYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA4 View Edit Remove
2BowAnthony8x5428abow@classicmodelcars.com11056Sales Manager (NA)San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA2 View Edit Remove
3JenningsLesliex540ljennings@classicmodelcars.com51143Sales Rep 20Tokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan6 View Edit Remove
4ThompsonLesliex4065lthompson@classicmodelcars.com11143Sales Rep 3San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA2 View Edit Remove
5FirrelliJuliex2173jfirrelli@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA1 View Edit Remove
6PattersonStevex4334spatterson@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA1 View Edit Remove
7VanaufGeorge Nx4102gvanauf@classicmodelcars.com31143Sales RepNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA4 View Edit Remove
8BondurLouix6493lbondur@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA0 View Edit Remove
9HernandezGerardx2028ghernande@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA0 View Edit Remove
10CastilloPamelax2759pcastillo@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA0 View Edit Remove
Search