>Hello,
>
>I have some SQL that 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'
group by 1
Does adding the GROUP BY above work?
Mark McCasland
Midlothian, TX USA