select p_Al.Alias, p_Al.Fin_Number,

case when p_p_r.PRSNL_PERSON_ID = p_Al.Alias then 1 else 2

as PCP

from table1 inner join table2 on (p_p_r.person_id = p_al.person_id)

quote:

---

Originally posted by cplusplus

Within my select how can i compare the two field column values and if match then 1 else 2, how can do that is it possible.

select p_Al.Alias, p_Al.Fin_Number,

case when p_p_r.PRSNL_PERSON_ID = p_Al.Alias then 1 else 2 END

as PCP

from table1 inner join table2 on (p_p_r.person_id = p_al.person_id)

Thank you very much for the helpful info.

---