Hi,

> I am storing beaucoup integers in a table which correspond to a
> multiple-choice selection (1 = excellent, 2 = good, etc.)
>
> When displaying the values on a form, I want to show those text values
> rather than integers.
>
> So, I created a table like:
>
> ID DESCRIPTION
> 1 Excellent
> 2 Good
>
> Etc.

> I tried the following SQL, but I'm pretty sure there's got to be an
> easier/more elegant way:

<snip a long unreadable query>

I'm pretty sure that there's normalization that can be done here.
(http://en.wikipedia.org/wiki/Database_normalization)
All these fields :
e.COMPENSATION
e.PERFORMANCE_REVIEW
e.BENEFITS
e.VACATION
...

could be in 1 single field which would finally result in a simple JOIN.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info