Re: ORDER BY a SubSelect?

I tried duplicating the entire subquery in the order by clauase and
Access gave me an error. The statement you put together with the outer
join works and gives me exactly what I was looking for. Thank you.

Also, you're right about always qualifying the names, that's much more
clear. Thanks again.

.

Relevant Pages

  • Re: ORDER BY a SubSelect?
    ... >I tried duplicating the entire subquery in the order by clauase and ... The statement you put together with the outer ...
    (comp.databases.ms-access)
  • Re: Query/Table term confusion
    ... --lets assume freight as an order amount on the northwind sample database. ... select OrderId, OrderDate, O.freight ... The O is an alias given to the outer table of the query. ... the subquery and the outer query alias is used. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Exists
    ... The correlation you're looking for is between a column in the table1 outer ... query and a column in the table2 subquery. ... > relate to the outer query? ...
    (microsoft.public.sqlserver.programming)
  • how to improve performance of LEFT JOIN
    ... I am developing reporting service and using lots of 'LEFT OUTER JOIN', ... FROM TableA ... LEFT OUTER JOIN TableB ... I add the subquery to query every table before 'LEFT JOIN' ...
    (comp.databases.ms-sqlserver)