Hi,
I have a report where I'm trying to sort by last name then first name. I cannot get the Order By command to work. Can someone share with me what I might be doing wrong? Syntax Below:
ORDER BY d.lname, d.fname DESC
I tried and it still does not work. Anything else I might try. Where you able to get it to work on your side.
Triland L. McConico
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Kaiser Sent: Friday, October 26, 2012 12:52 PM To: Triland McConico Subject: Re: [Tessitura Technical Forum] Order By Command Not Working
Try: ORDER BY d.lname, d.fname
From: Triland McConico <bounce-trilandmcconico7946@tessituranetwork.com> Sent: 10/25/2012 6:54:00 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Triland,
What is your desired result, and what are you getting that isn't working?
The line:
should order the results by lname _ascending_, followed by fname descending:
Adams John
Adams Abigail
Brown Sally
Brown Charlie
For ORDER BY "ascending " (asc) is implied, "descending" is must be specified, and you specify it column by column.
--Gawain