Hello all. We have a requirement to be able to sort our mailing output by account number - so as to better see the joint accounts (with two rows) and make checking mailing proofs much easier. We don't want to filter out any rows just change the order of the output.
I can see there are "windowing" or representation functions such as Desc and OrderBy but I get error messages about invalid aliases when trying to use them on the account number field and I suspect they might be meant to generate QUALIFY SQL statements and so might not be what I want directly...
I have looked at the docs and searched here but could find no solution. Does anyone have the answer to produce a simple ORDER BY?
PS: The answer does not have to in the direct mail step but those windowing functions could help and don't appear elsewhere that I have seen