>
>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