DB 썸네일형 리스트형 4중 LEFT OUTER JOIN... select m.AC_NO acNo, m.AC_TYPE acType, m.PROC_SID procSid, proc.NAME procName, proc.DESCRIPTION procDescription, proc.PROCESS_TIME processTime, p.PREV_AC_NO prevAcNo, n.NEXT_AC_NO nextAcNo from MW_BP_MAPP m LEFT OUTER JOIN MW_BP_MAPP_PREV p ON ( m.AC_NO=p.AC_NO ) LEFT OUTER JOIN MW_BP_MAPP_NEXT n ON ( m.AC_NO=n.AC_NO ) LEFT OUTER JOIN MW_PROC proc ON ( m.PROC_SID=proc.SID ) where BP_NO=61 심심해서 만.. 이전 1 다음
