Post reply

Inner join vs=

  • January 16, 2009 at 6:41 am

    #928052

    SELECT AR.SectionID ,O.OptionScore,AR.QuestionID,AR.SubSectionID

    FROM

    AuditResults AR

    INNER JOIN [Option] O

    ON AR.OptionID = O.OptionID

    and AR.QuestionID = O.QuestionID

    WHERE

    AR.SiteAuditID = 4602

    Order BY AR.SectionID

    Ie just move the and part from the where clause to the join clause..

    Mike John

  • January 16, 2009 at 6:51 am

    #928070

    I DIDNT KNOW THAT,

    Thank you very much.

  • January 16, 2009 at 7:36 am

    #928129

    omlac (1/16/2009)

    I DIDNT KNOW THAT,

    Thank you very much.

    yea you have too many things here to know ... that's nice to help each-other!

    You are welcome!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

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

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