Try this
select distinct(T1.Billno),T1.Billdate,T1.CCode,T1.CName,T1.Nettot as TotalAmount,
COALESCE(sum(T2.Paid),0) as Paid
,T1.Nettot- COALESCE(sum(T2.Paid),0) as Balance
from Billing1 T1
Left Outer Join Pending T2 On T1.Billno=T2.Billno
where T1.Cname='WelForge