posted 14 years ago
Thanks for your reply.
I think I made a mistake in writing query. It's like this:-
select *
from sb_skill_group sg Left outer join
(select * from vw_sub_campaign_view
where status in (1,2,3,4)
) sc on
(scv_skillgroup_guid = sg_uid)