Question Locked

SQL

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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....

1 reply

This discussion is closed to new replies.