Hi frnds....
i want to convert this query in linq..but i could not get success....So please help me out.
select * from (( select acc_id,0,Acc_name from acc_type where grp_id=7
and acc_id not in (select distinct acc_id from acc_subtype))
Union all ( SELECT acc_id,acc_sid,acc_sname FROM acc_subtype
where acc_id in (select acc_id from acc_type where grp_id=7))) as t order by acc_name
Thanks....