DeCode in Column List

[AccessHunter]

I am trying to run the query below and its giving me an error saying "single row subquery returns morethan one row". Is there an another way to do this?
I need Funding Source 17/18 as Yes/No column and Funding Source 28 as another Yes/No Column along with other coulmns.
PLease treat this as urgent.

Thanks.

SELECT Unique (ETA.CLNT_ID),
TC.CLNT_FNAME,
TC.CLNT_LNAME,
TC.CLNT_DOB,
LG.GENDER_NAME,
RACE_NAME,
ETA.ACCEPTED_DT,
ETA.TERMINATED_DT,
DECODE (FS1.FUNDING_SRC_ID, 17,'Yes',18,'Yes'),
(SELECT DECODE (FS2.FUNDING_SRC_ID, 28,'Yes')
FROM
APPLICATION.T_ET_ASSESSMENT ETA, APPLICATION.T_ET_ASMT_FUNDING_SOURCES FS2,
APPLICATION.T_CLIENT TC,
APPLICATION.L_GENDER LG,
APPLICATION.T_CLIENT_RACE TR,
APPLICATION.L_RACE LR

WHERE TC.CLNT_ID = ETA.CLNT_ID
AND TC.CLNT_ID = TR.CLNT_ID
AND TC.CLNT_ID = TR.CLNT_ID
AND ETA.ET_ID = FS2.ET_ID
AND TC.CLNT_GENDER = LG.GENDER_ID
AND TR.RACE_ID = LR.RACE_ID
AND TC.CLNT_DOB < to_date ('1992/01/01','yyyy/mm/dd')
AND (ETA.TERMINATED_DT > to_date ('2004/12/31','yyyy/mm/dd') OR ETA.TERMINATED_DT is null)
AND ETA.ACCEPTED_DT < to_date ('2006/01/01','yyyy/mm/dd')
AND FS2.FUNDING_SRC_ID = 28)

FROM APPLICATION.T_ET_ASSESSMENT ETA,
APPLICATION.T_ET_ASMT_FUNDING_SOURCES FS1,
APPLICATION.T_CLIENT TC,
APPLICATION.L_GENDER LG,
APPLICATION.T_CLIENT_RACE TR,
APPLICATION.L_RACE LR

WHERE TC.CLNT_ID = ETA.CLNT_ID
AND TC.CLNT_ID = TR.CLNT_ID
AND TC.CLNT_ID = TR.CLNT_ID
AND ETA.ET_ID = FS1.ET_ID
AND TC.CLNT_GENDER = LG.GENDER_ID
AND TR.RACE_ID = LR.RACE_ID
AND TC.CLNT_DOB < to_date ('1992/01/01','yyyy/mm/dd')
AND (ETA.TERMINATED_DT > to_date ('2004/12/31','yyyy/mm/dd') OR ETA.TERMINATED_DT is null)
AND ETA.ACCEPTED_DT < to_date ('2006/01/01','yyyy/mm/dd')
AND (FS1.FUNDING_SRC_ID = 17
OR FS1.FUNDING_SRC_ID = 18)

[amitpatel66]

I dont find any JOIN in the subquery that connects between itself and the outer MAIN query??.....You will need to link the MAIN query and the subquery in order to solve this problem

[AccessHunter]

How do I do that?

Thanks