Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
select distinct LOAD.LOAD ,LOAD.WEIGHT as LOAD_WEIGHT ,LOAD.cube as LOAD_CUBE ,FORMAT(LOAD.PERCENTFULL, '0.00') AS PENCENTAGE_FULL ,LOAD.TRIP ,LOAD.TRAVELEDDISTANCE ,LOAD.CARRIER ,LOAD.SERVICE ,MID(stop.location, INSTR(1, stop.location, ',') + 1, INSTR(INSTR(1, stop.location, ',') + 1, stop.location, ',') - INSTR(1, stop.location, ',') - 1) AS LOCATION ,LOC_AND_HIB.CITY ,LOC_AND_HIB.STATE ,STOP.DISTANCEFROMLAST ,stop.sequence AS SEQUENCE ,PICK_DROP.PICKDROP ,SHIPMENT.SHIPMENTID ,SHIPMENT.COMMODITYCODE ,SHIPMENT.WEIGHT as ORD_WEIGHT1 ,SHIPMENT.cube as ORD_CUBE1 ,SHIPMENT.PIECES AS ORD_PIECES ,SHIPMENT.SKIDS as ORD_PAL FROM ( ( Pick_Drop INNER JOIN Shipment ON Pick_Drop.ShipmentID = Shipment.ShipmentID ) INNER JOIN ( ( LOAD INNER JOIN Stop ON LOAD.LOAD = Stop.LOAD ) INNER JOIN loc_and_hib ON Stop.Location = loc_and_hib.LocationID ) ON (Pick_Drop.LOAD = LOAD.LOAD) AND (Pick_Drop.Sequence = Stop.Sequence) ) order by LOAD.LOAD ,stop.sequence;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.