UPDATE TR_REQ_PAY_INVOICE SET INVOICE_NO =INVOICE_NO+'XY' WHERE REQ_PAY_ID NOT IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT)

SELECT A.INVOICE_NO AS SO_HD, B.REQ_PAY_CODE AS SO_PHIEU_THANH_TOAN, B.MAKER_ID AS NGUOI_LAP_PHIEU FROM TR_REQ_PAY_INVOICE A
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID
WHERE A.INVOICE_NO ='0001580'