If you want to accumulate the result of two queries that return similar results, you can use the
UNION
operation.
As an example, see this
select sec_modules.modname_vc,
sec_roles.rolename_vc,
sec_functions.functionname_vc,'',''
from sec_umrf_details
left join sec_mrf_details on sec_umrf_details.mrfno_int = sec_mrf_details.mrfno_int
left join sec_modules on sec_modules.modid_int = sec_mrf_details.modid_int
left join sec_roles on sec_roles.roleid_int = sec_mrf_details.roleid_int
left join sec_functions on sec_functions.fnid_int = sec_mrf_details.fnid_int
where
sec_mrf_details.mrfno_int = (@mrfid)
group by sec_modules.modname_vc, sec_roles.rolename_vc, sec_functions.functionname_vc
UNION
select '','','',sec_umrf_details.mrfno_int from sec_umrf_details
where userid_vc = 'asda'