I have the following code where I have some subquery. However my subquery return more than 1 row. Is it some how I can put all subquery result in 1 row instead of couple?
select Custom1=(select case Answer when 'Yes' then 'Y' else 'N' end + ' '
fromAnswers wa where wa.tranid=wt.TranID ),
....
FROM trans wt ....
more joins
select Custom1=(select case Answer when 'Yes' then 'Y' else 'N' end + ' '
fromAnswers wa where wa.tranid=wt.TranID ),
....
FROM trans wt ....
more joins