select ibmdBLOOD_PACKET_SERIAL_NO as bloodbagibmdblood_name as pat_nameibmdTRANS_CAPACITY as amountibmdBLOOD_TYPE bloodgroup ibmdRH_TYPE rhibmdUNIT unitto_charibSEND_BLOOD_TIMEyyyy-MM-dd hh24mi out_da

SELECT ibmd.BLOOD_PACKET_SERIAL_NO AS "bloodbag", ibmd.blood_name AS "pat_name", ibmd.TRANS_CAPACITY AS "amount", ibmd.BLOOD_TYPE AS "bloodgroup", ibmd.RH_TYPE AS "rh", ibmd.UNIT AS "unit", TO_CHAR(ib.SEND_BLOOD_TIME, 'yyyy-MM-dd hh24:mi') AS "out_date", ibmd.BLOOD_DONORS AS "user_name" FROM idr.blood_match ibm LEFT JOIN idr.blood_match_detail ibmd ON ibm.match_blood_no = ibmd.match_blood_no LEFT JOIN idr.blood ib ON ib.MATCH_BLOOD_NO = ibmd.MATCH_BLOOD_N