DEMO SITE v1.7.26

Join other table Bootstrap theme

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
1MurphyDianex5800dmurphy@classicmodelcars.com58PresidentTokyo+81 33 224 50004-1 KioichoChiyoda-KuJapan102-8578Japan1 View Edit Remove
2PattersonMar'yx4611mpatterso@classicmodelcars.com11002VP SalesSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
3FirrelliJeffx9273jfirrelli@classicmodelcars.com11002VP MarketingSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
4PattersonWilliamx4871wpatterson@classicmodelcars.com71056Sales Manager (APAC)London+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA7 View Edit Remove
5BondurGerardx5408gbondur@classicmodelcars.com41056Sale Manager (EMEA)Paris+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA5 View Edit Remove
6BowAnthonyx5428abow@classicmodelcars.com11056Sales Manager (NA)San Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
7JenningsLesliex3291ljennings@classicmodelcars.com11143Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
8ThompsonLesliex4065lthompson@classicmodelcars.com11143Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
9FirrelliJuliex2173jfirrelli@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA2 View Edit Remove
10PattersonStevex4334spatterson@classicmodelcars.com21143Sales RepBoston+1 215 837 08251550 Court PlaceSuite 102MAUSA02107NA2 View Edit Remove
Search Execution time: 0.004 sMemory usage: 0.23 MB