>>>Did you have your answer with the responses in the SQL forum?
>>
>>Not sure yet. I'm going to look now!
>>
>>Pete
>
>I've tried out a few things that were suggested, but so far I haven't managed to get it working.
>
>Pete

I have managed to get things working (hopefully). I used a SQL statment like this:

select proread.*,usertab.us_desc as desc1,c.us_desc As desc2 from (usertab inner join proread on usertab.us_code=proread.pr_inttype) inner join usertab c on c.us_code=proread.pr_type where c.us_type='RE' and usertab.us_type='IT'

Pete