2.0 CHECK LOG DINH KEM FILE.txt - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Download (312 Bytes)

2.0 CHECK LOG DINH KEM FILE.txt

Luc Tran Van, 09/13/2021 08:36 PM

1

SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='092021/000280'

2

SELECT * FROM CM_ATTACH_FILE WHERE REF_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='092021/000280')

3

SELECT * FROM CM_ATTACH_FILE_LOG WHERE REF_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='092021/000280')