Post reply

Order By Clause Different in SQL2000 vs. SQL2005

  • April 1, 2009 at 9:19 am

    #969975

    All queries are now in the form of stored procedures. It makes it easier for them and for us.:-)

  • May 28, 2009 at 8:22 am

    #1001450

    Sorry to bring this thread up, but I'm still confused. WHat about the case where you have a query that joins two tables that have the same name, different data. If we can't use the prefix of the table alias how do we get it to sort by the proper columne?

    table employee (empid int,

    createdate datetime)

    table person (pid int,

    createdate datetime)

    As I understand the change this query is now incorrect in 2005...

    select p.createdate, e.createdate

    from employee e

    join person p on e.pid = p.empid

    order by e.createdate

    what am I not understanding?

    sean

  • May 28, 2009 at 8:25 am

    #1001455

    Nevermind I just re-read the whole documentation. The issue is when you prefix a table alias on a columns alais in an ORDER BY. This is not the case in my example.

    sean

Viewing 3 posts - 16 through 17 (of 17 total)

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