Hi guys,
The following query is not retuning any rows("0 rows selected"), while there are valid records matching the conditions. Can someone help in finding out the error?

select col1,col2,
decode(a.ittype,1,decode(a.itaddr,b.itaddr,b.servloc),
2,decode(a.itaddr,b.itaddr,b.servloc)) intended_servloc,
decode(a.ittype,3,decode(a.itaddr,c.itaddr,c.servloc),
4,decode(a.itaddr,c.itaddr,c.servloc)) actual_servloc
from a ,b,c;
Thanks
manjunath