I have a problem due to a redundancy data at my report.
The Code:
select jt.vc_sec_code, sc.vc_sec_desc, dm.vc_order, dm.vc_desig_code_pk, dm.vc_desig_desc, pt.vc_name, jt.n_ic_num_pk, pt.vc_ic_color, pt.d_dob,
jt.d_desig_jodt, jt.d_kenaikan, jt.n_sal
where jt.vc_sec_code = sc.vc_sec_code_pk
and jt.vc_sec_code = :section
and jt.n_ic_num_pk = pt.n_ic_num_pk
and jt.vc_desig_code = dm.vc_desig_code_pk
and pt.vc_sstatus = ‘S’
and jt.vc_jtype_code = ‘H’
from tbl_desig_mast dm, tbl_job_details_trans jt, tbl_personal_trans pt, tbl_sections_mast sc
order by dm.vc_order, jt.d_desig_jodt, pt.vc_name
Please Help….
