SELECT * FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE IN

(N'1778A/2019/TTr-KCNTT',
N'14/2019/TTr-BDA Omni Channel',
N'18/2019/TTr-GĐ-KCNTT',
N'019/2019/TTr-TTT',
N'06A/2019/TT-P.HC.XDCB',
N'13/2019/TTr-P.QLDA',
N'14/2019/TTr-P.QLDA',
N'2492A/2019/TTr-KCNTT',
N'05/2020/TTr-KCNTT',
N'11/2020/TTr-KCNTT',
N'09B/2020/Tr-KCNTT',
N'09A/2020/Tr-KCNTT',
N'041/2020/TTr-TTT',
N'001/2020/TTr-TTT',
N'013/2020/TTr-TTT',
N'482/2020/TTr-KCNTT',
N'000058/2020TTR-0690902',
N'08/2020/TTr-KCNTT',
N'15/2020/TTr-QLDVKH',
N'169/2020/TTr-SP&MKT',
N'12/2020/TTr-TGĐ-KCNTT')

SELECT * FROM dbo.PL_REQUEST_DOC_DT WHERE REQ_ID IN (


SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE IN

(N'1778A/2019/TTr-KCNTT',
N'14/2019/TTr-BDA Omni Channel',
N'18/2019/TTr-GĐ-KCNTT',
N'019/2019/TTr-TTT',
N'06A/2019/TT-P.HC.XDCB',
N'13/2019/TTr-P.QLDA',
N'14/2019/TTr-P.QLDA',
N'2492A/2019/TTr-KCNTT',
N'05/2020/TTr-KCNTT',
N'11/2020/TTr-KCNTT',
N'09B/2020/Tr-KCNTT',
N'09A/2020/Tr-KCNTT',
N'041/2020/TTr-TTT',
N'001/2020/TTr-TTT',
N'013/2020/TTr-TTT',
N'482/2020/TTr-KCNTT',
N'000058/2020TTR-0690902',
N'08/2020/TTr-KCNTT',
N'15/2020/TTr-QLDVKH',
N'169/2020/TTr-SP&MKT',
N'12/2020/TTr-TGĐ-KCNTT')


)




SELECT * FROM dbo.TR_REQUEST_DOC WHERE REQ_CODE IN

('PUR/2019/00008989',
'PUR/2019/00008857',
'PUR/2019/00008939',
'PUR/2019/00008164',
'PUR/2019/00008610',
'PUR/2019/00009130',
'PUR/2019/00009239',
'PUR/2020/00009297',
'PUR/2020/00009356',
'PUR/2020/00009357',
'PUR/2020/00009358',
'PUR/2020/00009359',
'PUR/2020/00009360',
'PUR/2020/00009361',
'PUR/2020/00009362',
'PUR/2020/00009448',
'PUR/2020/00009341',
'PUR/2020/00009343',
'PUR/2020/00009649',
'PUR/2020/00009347',
'PUR/2020/00009350',
'PUR/2020/00009645',
'PUR/2020/00009647',
'PUR/2020/00009590',
'PUR/2020/00009589',
'PUR/2020/00009325',
'PUR/2020/00009426',
'PUR/2020/00009644',
'PUR/2020/00009736',
'PUR/2020/00009507',
'PUR/2020/00009720',
'PUR/2020/00009765',
'PUR/2020/00009705')

SELECT * FROM dbo.TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN (


SELECT REQ_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_CODE IN

('PUR/2019/00008989',
'PUR/2019/00008857',
'PUR/2019/00008939',
'PUR/2019/00008164',
'PUR/2019/00008610',
'PUR/2019/00009130',
'PUR/2019/00009239',
'PUR/2020/00009297',
'PUR/2020/00009356',
'PUR/2020/00009357',
'PUR/2020/00009358',
'PUR/2020/00009359',
'PUR/2020/00009360',
'PUR/2020/00009361',
'PUR/2020/00009362',
'PUR/2020/00009448',
'PUR/2020/00009341',
'PUR/2020/00009343',
'PUR/2020/00009649',
'PUR/2020/00009347',
'PUR/2020/00009350',
'PUR/2020/00009645',
'PUR/2020/00009647',
'PUR/2020/00009590',
'PUR/2020/00009589',
'PUR/2020/00009325',
'PUR/2020/00009426',
'PUR/2020/00009644',
'PUR/2020/00009736',
'PUR/2020/00009507',
'PUR/2020/00009720',
'PUR/2020/00009765',
'PUR/2020/00009705')

)