DEMO SITE v1.7.15

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

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 
1ThompsonLesliex4065lthompson@classicmodelcars.com11143Sales RepSan Francisco+1 650 219 4782100 Market StreetSuite 300CAUSA94080NA3
2PattersonStevex4334spatterson@classicmodelcars.com31143Sales RepNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA4
3VanaufGeorgex4102gvanauf@classicmodelcars.com31143Sales RepNYC+1 212 555 3000523 East 53rd Streetapt. 5ANYUSA10022NA4
4BondurLouix6493lbondur@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA6
5CastilloPamelax2759pcastillo@classicmodelcars.com41102Sales RepParis+33 14 723 440443 Rue Jouffroy D'abbansFrance75017EMEA6
6BottLarryx2311lbott@classicmodelcars.com71102Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA1
7JonesBarryx102bjones@classicmodelcars.com71102Sales RepLondon+44 20 7877 204125 Old Broad StreetLevel 7UKEC2N 1HNEMEA1
8FixterAndyx101afixter@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC7
9MarshPeterx102pmarsh@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC7
10KingTomx103tking@classicmodelcars.com61088Sales RepSydney+61 2 9264 24515-11 Wentworth AvenueFloor #2AustraliaNSW 2010APAC7
Add Export into CSV Print
Search