Project

General

Profile

Download (338 Bytes)

1.4 CHECK NS 2 PO.txt

Luc Tran Van, 08/16/2021 08:28 PM

 
1 
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID IN ('TRRD00000253160','TRRD00000252757')
2 
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN ('TRRD00000253160','TRRD00000252757')
3 
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQDT_ID IN (SELECT PL_REQDT_ID FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN ('TRRD00000253160','TRRD00000252757'))
4 
---2021816