Support
Orange Support > 문의하기
Q & A
이것 해석좀 해주세요
Date2003.02.11 /
Hit : 14201
select m2.mw_afr_shtnm, concat('''', m2.cgg_mw_afr_cat_no) a, d1.dep_nm, d2.dep_nm, u.nm, u.usr_id, m2.web_appl_yn from caftn492 m, cmmtndptmnt d1, cmmtndptmnt d2, cmmtnorg o, caftn491 m2, cmmtnuser u where m.take_cgg_code = o.org_and_team_code and m.take_dep_code = d1.dep_code and m.deal_dep_code = d2.dep_code and m.cgg_mw_afr_cat_no = m2.cgg_mw_afr_cat_no and m.web_take_usr_id = u.usr_id (+) and length(m.cgg_mw_afr_cat_no) = 13 order by a