Hi All, I am trying to convert from implicit joins to explicit join. Below is the quey that I need to changeupdate history set C.nha_name_abbr = S.name_abbr , C.nha_pn_mk_mod = S.pn_mk_mod, C.nha_sn = S.sn, C.nha_mfr_lot = S.mfr_lot, C.nha_dup_flag = S.dup_flagfrom history C, MEDS.dbo.status Swhere C.nha_key_id_no *= S.key_id_no and C.nha_key_id_no > 0 and process_userid = @entry_userid
after I changed it, I have the query belowupdate history set C.nha_name_abbr = S.name_abbr , C.nha_pn_mk_mod = S.pn_mk_mod, C.nha_sn = S.sn, C.nha_mfr_lot = S.mfr_lot, C.nha_dup_flag = S.dup_flagfrom history C LEFT OUTER JOIN MEDS.dbo.status S ON (C.nha_key_id_no = S.key_id_no)where and C.nha_key_id_no > 0 and process_userid = @entry_userid
when I put those changes, I am getting an error sayingThe multi-part identifier "C.nha_name_abbr" could not be bound.I am not sure what am I doing wrong.
change from implicit join to explicit join
Posted - 2014-01-03 : 16:48:05
Tara Kizer