You're not clear on what you're trying to do, but I'll take a whack and solving what I think you want to get. Sounds like this is a homework assignment!
>From the sound of it, you want to know how many companies have proposals out and add that to the number of proposals that are outstanding, with no company associated with them. Think of it mathematically and you have your solution. Get the DISTINCT COUNT(COMPANYID) and add in the COUNT(PROPOSALID) WHERE COMPANYID="". The exact sytnax and implementation is up to you. ...Glenn On Wed, Sep 3, 2008 at 5:26 AM, pigsy101 <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
