-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|