Temp Billno Item Qty Rate amt Preferences 2 Icecream 2 10 20 Parcel 2 coffee 3 10 30 Parcel 1 Cream Salad 2 20 40 A/C 3 Cococola 5 15 60 Non A/C Billing Billno Billamt 2 90 1 40 3 60
BillNo Billamt 2 90
select billno,item from table where preferences='Parcel'
select billno,SUM(amt)as Billamt from temp where preferences='Parcel' group by billno
SELECT distinct Temp.Billno ,Billamt ,[item] FROM Temp t inner join billing b on t.BillNo=b.BillNo where preferences='Parcel'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)