DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

SELECT MAX(A.TYPE_ID) AS N'NHÓM CẤP 1', MAX(A.GROUP_CODE) AS N'MÃ NHÓM VẬT LIỆU', MAX(A.GROUP_NAME) AS N'TÊN NHÓM VẬT LIỆU',

MAX(B.GROUP_CODE) AS N'MÃ NHÓM CHA', MAX(B.GROUP_NAME) AS N' NHÓM VẬT LIỆU CHA',MAX(A.UNIT_ID) AS N'ĐƠN VỊ TÍNH', MAX(A.IS_LEAF) AS IS_LEAF, 

MAX(A.GROUP_LEVEL) AS LEVEL, MAX(A.EXP_ACCTNO) AS EXP_ACCTNO,

MAX(A.INC_ACCTNO) AS  INC_ACCTNO, MAX(A.LIQ_ACCTNO) AS LIQ_ACCTNO, MAX(A.MATERIAL_ACCTNO) AS MATERIAL_ACCTNO,

MAX(A.MATERIAL_ACCTNO_NHNN) AS MATERIAL_ACCTNO_NHNN, MAX(A.VAT_ACCTNO) AS VAT_ACCTNO, MAX(A.NOTES) AS N'GHI CHÚ'

FROM MW_GROUP A

LEFT JOIN MW_GROUP B ON A.PARENT_ID = B.GROUP_ID

GROUP BY A.GROUP_CODE

HAVING COUNT (*) =1

ORDER BY MAX(A.TYPE_ID) DESC, MAX(A.GROUP_LEVEL)