DEMO SITE v1.7.26

Join other table Bootstrap 4.5 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