Post reply

Record Count using TOP across multiple tables

  • October 10, 2008 at 1:08 am

    #883283

    Luke,

    I noticed something. After implementing that new query, some data isn't showing up. Specifically, Clients aren't being show where there are no associated projects. I've been playing around w/ it for a while and can't seem to figure it out. I know what the joins are keeping the records from returning, but can't get it to work w/ all of the clients shown.

    Any ideas?

    Thanks.

    Stephen

  • October 10, 2008 at 6:07 am

    #883361

    sorry I assumed that if you had a client, they would have had a project at some point in time or other...

    Just change the below to a left Join.

    FROM Clients c

    INNER JOIN [Projects] p

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 10, 2008 at 12:19 pm

    #883586

    Worked great. Thanks again.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply