>Eric,
>
>One (hopefully) last question:
>
>My SQL at present is:
>
>select proread.la_idla,usertab.us_desc as desc1, '' as desc2
>from proread, usertab
>where proread.pr_inttype=usertab.us_code and usertab.us_type='IT'
>union
>select proread.la_idla,'',usertab.us_desc
>from proread, usertab
>where proread.pr_type=usertab.us_code and usertab.us_type='RE'
>
>This does return the correct rows. However, there are 2 rows per la_idla. I would like there to be a single row for each la_idla field, with desc1 and desc2 appearing on the same row.
>
>Hopefully there is a simple way in which to do this, but it escapes me at present.
>
>Pete

Post your question in the SQL groug. Michael surely have an answer for you using a Select Case (I will follow that thread too!).