SELECT * FROM divisioncarrier, carrier 
			WHERE division_id = '100' AND divisioncarrier.carrier_id = carrier.carrier_id ORDER BY dc_order, c_name