Project

General

Profile

TL_USER.txt

Luc Tran Van, 11/30/2022 11:51 AM

 
1
SELECT COUNT(*) FROM TL_USER tu WHERE tu.DEP_ID IS NULL OR tu.SECUR_CODE IS NULL
2
SELECT tu.TLNANME,tu.TLSUBBRID,tu.DEP_ID,tu.SECUR_CODE FROM TL_USER tu WHERE tu.DEP_ID IS NULL OR tu.SECUR_CODE IS NULL