APEX

Hi everybody!

I'm testing the HTML DB at the moment and I want to create a report with a select list which is used within a condition.
I have a column with timestamps and want to use this records for extracting the year of the timestamps for the list of values.
I created a select statement which delivers exactly that what I am looking for:

SELECT DISTINCT TO_CHAR(TRUNC(TIMES.TRANSACTION_DATE), 'YYYY') AS d, TO_CHAR(TRUNC(TIMES.TRANSACTION_DATE), 'YYYY') AS r FROM VIDEO5.TIMES TIMES;

Result:
D R
1998 1998
1999 1999
2000 2000

When I use this query in a LOV I always get the error message:
"LOV query is invalid, a display and a return value are needed, the column names need to be different. If your query contains an in-line query, the first FROM clause in the SQL statement must not belong to the in-line query."

Has anybody an idea why this is not working?

Best regards,

Christian