'order by' in an sql

L

Lee

I finally wrote union statement in an sql that didn't give me an error
message. However, I wanted to sort by the second field I listed. I used the
line ORDER BY [last name] The query is still sorting by first name. I am
working in XP office professional.
 
V

Van T. Dinh

[last name] must be in the Field list of the first part (left part) of the
Union.

If [last name] is already in the first part, post your SQL String.
 
Top