Post reply

LEFT OUTER JOIN

  • July 13, 2009 at 4:18 am

    #134252

    Hi,

    The command "LEFT OUTER JOIN" does not work in SQL Server 2005.

    I can replace it for LEFT JOIN.

    Do this two commands do the exact same thing?

    thank you

  • July 13, 2009 at 4:20 am

    #1023767

    Hi ,

    how do you mean doesn't work ?

    Can you post the full query ?


    Clear Sky SQL
    My Blog[/url]

  • July 13, 2009 at 4:35 am

    #1023771

    Hi

    It will works

    Please post the query .

    Rgards

    sat_sql

  • July 14, 2009 at 6:32 am

    #1024355

    The older LEFT|RIGHT OUTER JOIN operator syntax no longer works such as '*=' or '=*', but the explicit LEFT|RIGHT OUTER JOIN syntax still does even with the compatibility level set to 90 in my experience.


    maddog

  • July 14, 2009 at 6:45 am

    #1024366

    river (7/13/2009)

    The command "LEFT OUTER JOIN" does not work in SQL Server 2005.

    I can replace it for LEFT JOIN.

    LEFT OUTER JOIN works very well in SQL Server 2000, 2005 and 2008. Why do you say it does not?

    LEFT JOIN and LEFT OUTER JOIN are identical. If you check Books Online for the syntax of the FROM clause, you'll see that the OUTER keyword is optional.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 14, 2009 at 7:14 am

    #1024382

    Hi Gail,

    Thank you very much.

    I was wrong.

    I tested again, and it works.

    sorry for the wrong information.

    thank you all, for reply to this post

  • July 15, 2009 at 6:58 am

    #1024992

    river (7/13/2009)

    Hi,

    The command "LEFT OUTER JOIN" does not work in SQL Server 2005.

    I can replace it for LEFT JOIN.

    ....:w00t::-):w00t::-):w00t::-):w00t:

    --
    :hehe:

Viewing 7 posts - 1 through 6 (of 6 total)

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