Try this:
select a.billamt,b.itemcode,(select TOP(1) IsActivated from tblSuperSellDetail where SellId=7) as isactivated
from tblSellMaster a inner join tblSellDetail b on a.SellId =b.SellId
where a.SellId =7
NOTE: This is not prefered solution. Rather then using subquery, use
JOIN
to join next table ;)