author: @ftama tags:#sql#query,#transpose
UNTUK RESULT MASIH TIDAK SESUAI !!!
SELECT a.qty AS total_distance,
b.qty/1000 AS total_coal
FROM
T_Adjustment a JOIN T_Adjustment B ON a.transaksi = 'Distance CG'
AND b.transaksi = 'Coal Getting'Returns:
