这是我写的SQL:
select comcname from
(
select cgm.user_id, cgm.user_name user_name, com.comcode, com.comcname comcname
from COGNOS_GROUP_MEMBER CGM, CD_COM_LEVEL COM
where (CGM.USER_CLASS_ID = COM.COMCODE1 OR
CGM.USER_CLASS_ID = COM.COMCODE2 OR
CGM.USER_CLASS_ID = COM.COMCODE3 OR
CGM.USER_CLASS_ID = COM.COMCODE4 OR
CGM.USER_CLASS_ID = 'Root User Class')
)
where user_name = {_USER_}