Hallo Lukas!

>> 4) UNION
>>
>> select
>> cursus_code as code,
>> cursus_descr_nl as descr
>> from cursustype
>> where (pk_cursustype = :type)
>> and (:language = 'nl')
>> union
>> select
>> cursus_code as code,
>> cursus_descr_en as descr
>> from cursustype
>> where (pk_cursustype = :type)
>> and (:language = 'en')
>
>but those will only work for two columns.

That's what Erik asked for.

>If there are <n> columns you have to write a union statement for every
>column.

Sure, this is how UNION works. I supposed it was obvious that a simple
Copy&Paste for every supported language will do it.

Christian