I have a list of proposal id and company id
a company id can have many proposal id's only there isn't always a
company id but there is always a proposal id
eg
proposal id company id
1 10
2 10
3 11
4 12
5
6
7 13
8 13
I can do a distinctcount on company id that gives a result of 4 but i
need to add in the 2 blanks too to give a result of 6. is this
possible.
Many thanks in advance
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
