Forum Replies Created

Viewing 2 posts - 76 through 78 (of 78 total)

  • RE: Sub query expressions vs. Joins.

    crackbridge (7/22/2010)

    Its interesting your article, one thing its not clear enought to me is why do you open your article with a GROUP and COUNT issue but later you develop...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    July 23, 2010 at 12:26 am

    #1197349

  • RE: Sub query expressions vs. Joins.

    tim.napier (7/21/2010)

    What happens if you use a left join in the second of the two queries. The fact they both returned 40000 rows is by coincidence, cos the sub select...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    July 23, 2010 at 12:21 am

    #1197347

Viewing 2 posts - 76 through 78 (of 78 total)