DEMO SITE v1.7.20

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();
	
	 
	
?>
<script>
			$(document).ready(function() {
				$(".xcrud-list").tableHeadFixer({"head" : false, "left" : 2}); 
			});
		</script>

Employees

#LastnameFirstnameExtensionEmailOfficecodeReportstoJobtitleCityPhoneAddressline1Addressline2StateCountryPostalcodeTerritoryOrdering 
1dxAnthonyw2x5428abow@classicmodelcars.com31056Sales Manager (NA)NYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA1 View Edit Remove
2JenningsfLesliex3291ljennings@classicmodelcars.com11156Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA0 View Edit Remove
3FirrelliJulieettekx2173jfirrelli@classicmodelcars.com61143Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC6 View Edit Remove
4BondurLouix6493lbondur@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA5 View Edit Remove
5HernandezGerardx2028ghernande@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA5 View Edit Remove
6CastilloPamelax2759pcastillo@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA5 View Edit Remove
7BottLarryx2311lbott@classicmodelcars.com71102Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA7 View Edit Remove
8JonesBarryx102bjones@classicmodelcars.com71102Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA7 View Edit Remove
9FixterAndyx101afixter@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC6 View Edit Remove
10MarshPeterx102pmarsh@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC6 View Edit Remove
Search