Support #835: Cập nhật hạng mục ngân sách bị trống - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT - Redmine

Support #835

Status:

Closed

Priority:

Normal

Assignee:

Start date:

01/19/2021

Due date:

% Done:

Estimated time:

INS CM_GOODS.txt (866 Bytes) INS CM_GOODS.txt		Truong Nguyen Vu, 01/19/2021 09:24 AM
PL_REQUEST_DOC_DT_ById.txt (14.3 KB) PL_REQUEST_DOC_DT_ById.txt		Truong Nguyen Vu, 01/19/2021 01:57 PM
PL_REQUEST_DOC_DT_Search.txt (5.37 KB) PL_REQUEST_DOC_DT_Search.txt		Truong Nguyen Vu, 01/19/2021 01:57 PM
PL_REQUEST_TRANSFER_ByID.txt (11.1 KB) PL_REQUEST_TRANSFER_ByID.txt		Truong Nguyen Vu, 01/19/2021 01:57 PM
rpt_PL_REQUEST_DOC_DT_ById.txt (21.7 KB) rpt_PL_REQUEST_DOC_DT_ById.txt		Truong Nguyen Vu, 01/19/2021 01:57 PM
TR_REQ_PAY_BUDGET_ByID.txt (783 Bytes) TR_REQ_PAY_BUDGET_ByID.txt		Truong Nguyen Vu, 01/19/2021 01:57 PM
PL REQ GOOD SEARCH.txt (31.3 KB) PL REQ GOOD SEARCH.txt		Luc Tran Van, 01/19/2021 02:07 PM
TR_REQ_GOOD_BYCONTRACT.txt (6.48 KB) TR_REQ_GOOD_BYCONTRACT.txt		Truong Nguyen Vu, 01/19/2021 02:23 PM
PL_REQ_GOOD_Search.txt (16 KB) PL_REQ_GOOD_Search.txt		Truong Nguyen Vu, 01/19/2021 02:23 PM
PL_REQ_GOOD_GetById.txt (4.27 KB) PL_REQ_GOOD_GetById.txt		Truong Nguyen Vu, 01/19/2021 02:23 PM

SELECT IM.* FROM dbo.PL_IMPORT_DT IM
LEFT JOIN dbo.CM_GOODS CG ON IM.GOOD_ID=CG.GD_ID
WHERE CG.GD_ID IS NULL

Also available in: Atom PDF