这个sql查询语句怎么看

Question

SELECT CodeDef_int_CodeID,
CodeDef_int_CodeTypeID,
CodeDef_var_CodeCaption,
CodeDef_var_CodeValue,
CodeDef_var_CodeAbbreviation
FROM tbUCT_CodeDefine(nolock)
WHERE CodeDef_bit_IsDeleted=0
AND CodeDef_int_ParentID IN
(SELECT InnerID
FROM tbUCT_CodeDefine(nolock)
WHERE CodeDef_var_CodeValue='1'
AND CodeDef_int_CodeTypeID=
(SELECT top 1 CodeType_int_CodeParentID
FROM tbUCT_CodeTypeDefine(nolock)
WHERE CodeType_bit_IsDeleted =0
AND codetype_var_codetype = 'WorkTicket_SuperCategory'))
AND CodeDef_int_CodeTypeID =
(SELECT top 1 innerid
FROM tbUCT_CodeTypeDefine(nolock)
WHERE CodeType_bit_IsDeleted =0
AND codetype_var_codetype = 'WorkTicket_SuperCategory')
ORDER BY CodeDef_int_CodeSeq

Answer 1

也不复杂啊