Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

thanks a lott Doug,

your answer from a year ago solved my problem. (in this year, I didn't work on this project for at least 50weeks)

I lack ability too understand the first part, but after using the second part of your post i succeeded. the subsequence in this part did the trick:

SELECT "nm", "birthdayall" FROM ( SELECT "name01" ... FROM "tbl1" WHERE ... UNION ... ) AS "subq" ORDER BY "birthdayall"

do I have to mark this thread as SOLVED?

thanks, greetings 415flip