in my asp.net+vb web with access database. i am using a query (which was solved by this site).
SELECT AUTH.company
,AUTH.Auth
,Count(AUTH.company) AS Held
,(AUTH.Auth - Count(AUTH.company)) as [Sur/Defi]
FROM pers INNER JOIN AUTH ON pers.company = AUTH.company
GROUP BY AUTH.company,AUTH.Auth
The result after the above query is as under
Company Auth Held
Tata 12 02
Dell 11 08
HP 21 20
Opera 11 12
Bangour 10 12
i am willing to add the difference between Auth and Held as Sur/Defi