CHECK HOA DON 0001580.txt
| 1 |
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) |
|---|---|
| 2 |
|
| 3 |
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 |
| 4 |
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID |
| 5 |
WHERE A.INVOICE_NO ='0001580' |