SELECT A.LINE_NO ,A.BYPASS_TRNSSECT_CODE ,A.BYPASS_START_NAME ,A.BYPASS_END_NAME ,D.PASS_TIME ,D.AVR_SPED ,D.FLOW_CRCM ,A.BYPASS_ID FROM OM_BYPASS_INFO A , OM_BYPASS_LINK_MATCH B , OM_SECT_MST_TEMP C , OM_TRNS_INFO_SECT_NEW_TEMP D , OM_TRNS_INFO_BYPASS_MATCH E WHERE A.BYPASS_ID = B.BYPASS_ID AND B.INFO_OFFR_CNTR_SECT_ID = C.INFO_OFFR_CNTR_SECT_ID AND C.INFO_OFFR_CNTR_SECT_ID = D.INFO_OFFR_CNTR_SECT_ID AND C.INFO_OFFR_CNTR_SECT_ID = E.INFO_OFFR_CNTR_SECT_ID AND A.BYPASS_TRNSSECT_CODE != 0 GROUP BY A.BYPASS_ID, A.BYPASS_TRNSSECT_CODE, A.LINE_NO, A.BYPASS_START_NAME, A.BYPASS_END_NAME, D.PASS_TIME, D.AVR_SPED, D.FLOW_CRCM ;
A.BYPASS_ID 이 컬럼을 그룹바이 해줬는데 왜 같은 id값이 ..나오나요??
조언 부탁드립니다.
group by를 잘못한건가요?