Well the question looks complicated actually is it possible to have a select within a case which is a part of select thats my question.
Select field a, field b
WHEN A.MOB_NTWK_TYP_CDE='GSM' and b.Date>=current date
THEN (select b.val from tablea ,tableb where a.no=b.no and a.date=b.date)
so is it possible to have this select with the case statement early response is highly appreciated.