RE: SQL and Order By Question

OK, that's and odd request. This would work, but it's ugly:

Select key, desc, 1 from table where key='a' union
Select key, desc, 2 from table where key='c' union
Select key, desc, 3 from table where key='d' union
Select key, desc, 4 from table where key='b'
Order by 3

However, is that actually what you're trying to do? Or is it more like
the key field is a FK reference to another table, and you want to sort
on the description in that other table and the order results in the key
in your table sorting as a, c, d, b? If so, just join and sort on the
right field.

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
mailto:WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
To post a message email: mailto:JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: mailto:JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.