how do i return a result set back as one column?
select Distinct((LEFT(RIGHT(GLTran.Sub, 20), 3))) AS SubAcct , Account.Descr
INNER JOIN Account ON GLTran.Acct = Account.Acct
where GLTran.Acct >= '40000' AND GLTran.Acct < '50000' order by SubAcct asc
000 (Gain)/Loss Extin of Debt
want 1 col instead of 2
000 - Gain/Loss Extin of Debt