April 1, 2009 at 9:19 am
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
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
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