Post reply

Help needed on 3 table query

  • August 24, 2005 at 12:01 pm

    #584725

    I think something like this will do :

    Select T.id, ISNULL(dta.TA, 0) as TA, ISNULL(dtb.TB, 0) as TB from table1 T left outer join

    (Select ida, count(*) as TA from table1A group by ida) dta

    on T.id = dta.ida left outer join

    (Select idb, count(*) as TB from table1B group by idb) dtb

    on T.id = dtb.idb

  • August 24, 2005 at 12:14 pm

    #584732

    Remi....

    Thanks for the reply.  Your SQL skills go far beyond mine (which is not hard to do).  I am going to have to study this code for awhile to understand what you are trying to do.

    Thanks again.   Russ...

  • August 24, 2005 at 12:21 pm

    #584735

    HTH... Books online is your best friend now .

Viewing 3 posts - 1 through 4 (of 4 total)

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