I have built an SQL that extract data from a couple of tables.
I just want to remove some duplicate informations to give the report a clean look,
The SQL i use is:
select distinct LOAD.LOAD
,LOAD.WEIGHT as LOAD_WEIGHT
,LOAD.cube as LOAD_CUBE
,FORMAT(LOAD.PERCENTFULL, '0.00') AS PENCENTAGE_FULL
,MID(stop.location, INSTR(1, stop.location, ',') + 1, INSTR(INSTR(1, stop.location, ',') + 1, stop.location, ',') - INSTR(1, stop.location, ',') - 1) AS LOCATION
,stop.sequence AS SEQUENCE
,SHIPMENT.WEIGHT as ORD_WEIGHT1
,SHIPMENT.cube as ORD_CUBE1
,SHIPMENT.PIECES AS ORD_PIECES
,SHIPMENT.SKIDS as ORD_PAL
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
If you look in the first 13 columns from the BEFORE Picture below, you will see that you have multiple time the same values in multiple rows.
What i would like to do in the below picture AFTER is to leave the spaces empty when it is the same value. It would only show on the first row .
How can i update the Query?