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

Comments

Popular posts from this blog