select m.plan_cd,plan_name,charge_type,plan_charge,charge_free,charge_rate
from plan_master m,plan_detail d where m.plan_cd=d.plan_cd; # alias and condition
order by m.plan_cd, charge_type ; #confirm...have doubt
from plan_master m,plan_detail d where m.plan_cd=d.plan_cd; # alias and condition
order by m.plan_cd, charge_type ; #confirm...have doubt
Comments
Post a Comment