sql行转列

SELECT A.lot_id ,A.lot_rrn ,A.reticle_rrn,
   MAX(CASE A.trans_id WHEN 'MOVEIN' THEN A.trans_end_timestamp ELSE null END) startday,
   MAX(CASE A.trans_id WHEN 'MOVEOUT' THEN A.trans_end_timestamp ELSE null END) endday
   FROM (
        SELECT l.lot_id,l.lot_rrn ,ls.reticle_rrn,lt.trans_rrn, lt.trans_id ,tl.trans_end_timestamp
         FROM LOT l  
         JOIN lot_step_history ls ON ls.reticle_rrn <>0 AND l.lot_rrn = ls.lot_rrn 
         JOIN lot_trans_history lt ON l.lot_rrn = lt.lot_rrn AND (lt.trans_id = 'MOVEIN' OR lt.trans_id = 'MOVEOUT')
         JOIN transaction_log tl ON tl.trans_rrn = lt.trans_rrn
         WHERE l.lot_rrn = 52360311  
    ) A
GROUP BY A.lot_id,A.lot_rrn ,A.reticle_rrn