Post reply

Conversion of a query from SQl 2000 to SQL 2008 compatibility

  • August 11, 2011 at 11:31 pm

    #246186

    How to convert the below query to the SQL 2008 Compatibility:-

    select a.col1,

    a.col2,

    b.col1,

    b.col2

    from A, B, C

    where A.col1 *= B.col1

    and C.col1 *= B.col2

    Thanks for the replies

  • August 12, 2011 at 12:27 am

    #1367724

    vijayakumarn (8/11/2011)

    How to convert the below query to the SQL 2008 Compatibility:-

    select a.col1,

    a.col2,

    b.col1,

    b.col2

    from A, B, C

    where A.col1 *= B.col1

    and C.col1 *= B.col2

    Thanks for the replies

    First, a hint to get you going. You want to look up LEFT OUTER JOINs in Books Online. Read about those and how they are written and see if you can figure out the needed changes. We'll be here if you have any questions.

Viewing 2 posts - 1 through 1 (of 1 total)

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