CREATE VIEW VIEW_MENU
AS
SELECT *
FROM TABLE( MULTISET (
SELECT A.V_UMENUID, A.V_MENUID, A.N_SEQNO, A.V_MENUNM,
(SELECT A.N_SEQ_LEVEL - N_SEQ_LEVEL
FROM SSM_MENU
WHERE V_MENUID = 'S000001' ) AS N_TREE_LEVEL,
A.N_SEQ_LEVEL,
A.V_HIERARCHY, A.V_PAGEID,
NVL(B.V_PAGE_URL,'') AS V_PAGE_URL,
A.V_MENUID AS V_PAGE_MENUID
FROM SSM_MENU A LEFT OUTER JOIN SSM_PAGE B
ON A.V_PAGEID = B.V_PAGEID
WHERE NVL(A.V_FLAG_USE, 'Y') = 'Y'
AND A.V_HIERARCHY LIKE '%.S000001.%') ) MENU
위에 쿼리를 시행하면 아래의 에러 메시지가 나오는데요.. 이유가 뭘까요..
view 생성하는넘 빼고 돌리면 잘나옵니다.. 알려 주세요.. 여렵다 informix ㅠ0ㅠ
9806: Can not have duplicate/null field names in unnamed row types.
|