>>
>>Try something like:

>>select proread.la_idla,desc1 = case usertab.us_type when 'IT' then usertab.us_desc else '' end,
>>   desc2 = case usertab.us_type when 'RE' then usertab.us_desc else '' end
>>   from proread, usertab
>>   where proread.pr_inttype=usertab.us_code

>>HTH.
>
>This doesn't do what I need, but it will probably help. It's somehting for me to play with.
>
>Thanks,
>
>Pete

Yes you could add the 'IT' and 'RE' criteria to the WHERE clause so it only picks up those records. Otherwise, it picks up everything and you could conceivably have both fields blank (which isn't what you want).