Thanks now I have to include this in a view.

Well now I'm getting 3 records.

I put this in my select statement and I get no errors

, x.FAC_ACTIVITY[FAC_ACTIVITY]

, x.NUMMAINTEMP[NUMMAINTEMP]

, LH.dtLeaseFrom [LHdtLeaseFrom]

, LH.dtLeaseTo [LHdtleaseto]

, crp.destimated [crpdestimated]

--, pps.HValue [ppsNSFFEE]

,NSFFee = CASE WHEN pps.STYPE = 'nsffee' THEN pps.hvalue END

,MTMFee = CASE WHEN pps.STYPE = 'MTMFee' THEN pps.hvalue END

,SecDepIntRate = CASE WHEN pps.STYPE = 'DDEPOSITINTEREST' THEN pps.hvalue END

, m.stext [memoStext]

This what I put in my where cause

fromvw_DK_RMMISCDATA x

left joinProperty p on x.RM_ID = p.sCode

left join PROPOPTIONS pps on p.hmy = pps.HPROP and STYPE IN ('nsffee', 'MTMFee', 'DDEPOSITINTEREST')