I am getting error subquery return more than one value

I got the solution by using union

 

 

 

declare @P_INT_USER_ID int
SET @P_INT_USER_ID=4493
SELECT C.INT_CONSENTSOURCE_ID as ID,
P.INT_APP_ID as AppID,P.VCH_APP_NAME as AppName,
P.VCH_APP_ID as AppNo,M.VCH_MINERAL_NAME as MineralName,
C.VCH_CONSENT_SOURCE as ConsentSource,'CS' as Tname,
C.VCH_CONSENT_FILE as VCH_CONSENT_FILE------------------------added by ankit kumar on 12 Jan 2016
FROM T_FORMA_CONSENTSOURCE C,M_FORMA_PART1 P,M_MINES_MINERAL M
WHERE P.INT_USER_ID IN


( (SELECT INT_USER_ID FROM M_LICENSEE WHERE INT_LICENSEE_ID IN
(
SELECT INT_INACTIVE_ID FROM T_MIS_ACTIVE_TAGGING WHERE INT_ACTIVE_ID=
(
SELECT INT_LICENSEE_ID FROM M_LICENSEE WHERE INT_USER_ID= @P_INT_USER_ID AND BIT_DELETED_FLAG=0

)
)

)
union
select @P_INT_USER_ID as INT_USER_ID

)


AND P.INT_APP_ID=C.INT_APP_ID
AND C.INT_MINERAL_ID=M.INT_MINERAL_ID
AND P.INT_LICENSE_TYPE=2
AND P.INT_APPROVE_STATUS=1
AND C.BIT_DELETED_FLAG=0 AND P.BIT_DELETED_FLAG=0 AND M.BIT_DELETED_FLAG=0 

I think this line of query return more then one column check it

 

 

SELECT INT_LICENSEE_ID FROM M_LICENSEE WHERE INT_USER_ID= @P_INT_USER_ID AND BIT_DELETED_FLAG=0