| [ CNU ] in KIDS 글 쓴 이(By): Darkness (Dawn Lord) 날 짜 (Date): 2000년 5월 29일 월요일 오후 07시 42분 38초 제 목(Title): 그냥.... 낙서 SELECT S.*,C16.cde02_name,C03.cde02_name,C031.cde02_name,C04.cde02_name,C10.dept_mname,C.cst01_nameh , d1.dbi03_name,s1.ord02_size, E1.dbi01_name, E1.dbi01_size, H1.gds01_size, I1.dbi02_name, F1.asy01_size FROM bjobbrr02 S,cstdcst01 C, ssalord02 S1, cstddbi03 D1, ssalord04 H1, cstddbi01 E1,ssalord05 F1,cstddbi02 I1,(SELECT cde02_code, cde02_name FROM cstdcde02 WHERE cde01_code = '16' ) C16,(SELECT cde02_code, cde02_name FROM cstdcde02 WHERE cde01_code = '03' ) C03, (SELECT cde02_code, cde02_name FROM cstdcde02 WHERE cde01_code = '03' ) C031, (SELECT cde02_code, cde02_name FROM cstdcde02 WHERE cde01_code = '04' ) C04, (SELECT dept_code, dept_mname FROM INSA.ideptcode WHERE cpy_code LIKE '%' ) C10 WHERE S.suj01_code = 'C01' AND S.brr01_code = '20000507001' AND S.brr02_sno LIKE '01' AND S.cst01_code = C.cst01_code(+) AND S.mat01_cmat = C16.cde02_code(+) AND S.brr02_csunit = C03.cde02_code(+) AND S.brr02_cconv = C031.cde02_code(+) AND S.brr02_cstr = C04.cde02_code(+) AND S.brr02_cdpt = C10.dept_code(+)and s.ord01_code = s1.ord01_code(+)and s.ord02_code = s1.ord02_code(+) AND S1.suj01_code = D1.suj01_code(+) AND SubStr(S1.ord02_code,6,LENGTH(S1.ord02_code) - 5) = D1.dbi03_code(+) AND SubStr(S1.ord02_code,3,3) = D1.dbi03_cteam(+) AND S.suj01_code = H1.suj01_code(+) AND S.ord01_code = H1.ord01_code(+) AND S.ord02_code = H1.ord02_code(+) AND S.gds01_code = H1.gds01_code(+) AND H1.suj01_code = E1.suj01_code(+) AND SubStr(H1.gds01_code,4,LENGTH(H1.gds01_code) - 5) = E1.dbi01_code(+) AND SubStr(H1.gds01_code,1,3) = E1.dbi01_cteam(+) AND S.suj01_code = F1.suj01_code(+) AND S.ord01_code = F1.ord01_code(+) AND S.ord02_code = F1.ord02_code(+) AND S.gds01_code = F1.gds01_code(+) AND S.asy01_code = F1.asy01_code(+) AND S.suj01_code = F1.suj01_code(+) AND SubStr(F1.asy01_code,4,LENGTH(F1.asy01_code) - 5) = I1.dbi02_code(+) AND SubStr(F1.asy01_code,1,3) = I1.dbi02_cteam(+) 으앙... 이제 쿼리 보기만 해도 짜증이.... |