Selecting specific data

[saina]

Hi,
I have query which goes like this

select b.name,a.id,i.bonus,r.rating,m.merit
from sps_ee a,sps_dept b,
(select id,ee_att_value bonus from ws_sps_ee_att d where d.ee_class_id=11 and d.ee_att_id=1) i,
(select id,ee_att_value rating from ws_sps_ee_att d where d.ee_class_id=7 and d.ee_att_id=20) r,
(select id,ee_att_value merit from ws_sps_ee_att b where b.ee_class_id=1 and b.ee_att_id=1) m

where a.id=i.id and a.id=r.id and a.id=m.id


now i need to find data from tables r,i,m where the value (bonus,rating,merit)is 0 and replace with X

It will helpful if someone can help me
thanks

 

[r937]

what does "where the value (bonus,rating,merit) is 0" mean? all three values equal to 0? three values add up to 0? any of the three equal to 0?

and what does "replace with X" mean? another number, or the character string "X"?


r937.com | rudy.ca

 

[saina]

By "where the value (bonus,rating,merit) is 0" i mean either bonus=0,rating=0,merit=0.I wnat to replace the value by character X.
Thanks