Re: ORDER BY a SubSelect?

From: Steve Jorgensen <nospam@xxxxxxxxxxxxx>
Date: Thu, 22 Sep 2005 22:35:01 -0700

On 22 Sep 2005 09:10:40 -0700, dtwalter@xxxxxxxxx wrote:

>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

You probably pasted the " As <fieldname>" part. That part is not valid in the
ORDER BY clause.

>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.

.

References:
- ORDER BY a SubSelect?
  - From: dtwalter
- Re: ORDER BY a SubSelect?
  - From: Steve Jorgensen
- Re: ORDER BY a SubSelect?
  - From: dtwalter

Prev by Date: The EXISTS operator in A97 SQL - I cannot find documentation on it in A97 HELP
Next by Date: Select multiple date fields from one table
Previous by thread: Re: ORDER BY a SubSelect?
Next by thread: Printer Orientation and PrtDevMode MSDN example not working
Index(es):
- Date
- Thread

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)