Join other table Default theme

Allows you to join other tables. Only INNER JOIN supported. Keys in all joined tables must exist and be unique

<?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 
1MurphyDianex5800dmurphy@classicmodelcars.com58PresidentTokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan3
2PattersonMar'yx4611mpatterso@classicmodelcars.com11002VP SalesSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA6
3FirrelliJeffx9273jfirrelli@classicmodelcars.com11002VP MarketingSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA6
4PattersonWilliamx4871wpatterson@classicmodelcars.com61056Sales Manager (APAC)Sydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC1
5BondurGerardx5408gbondur@classicmodelcars.com41056Sale Manager (EMEA)Paris+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA0
6BowAnthonyx5428abow@classicmodelcars.com11056Sales Manager (NA)San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA6
7JenningsLesliex3291ljennings@classicmodelcars.com11143Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA6
8ThompsonLesliex4065lthompson@classicmodelcars.com11143Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA6
9FirrelliJuliex2173jfirrelli@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA2
10PattersonStevex4334spatterson@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA2
Add Export into CSV PrintSearch

 
Buy it nowfor only $13