테이블 데이타도 같고 쿼리문도 같은데 쿼리결과값이 다르게 나올 수 있나요?
레코드가 20개 정도가 인터베이스 쪽이 더 나오네요
참고로 쿼리문은 다음입니다.
select (a.fRes1_code) A, (a.fR_jung) B,(b.stud_name) C, (b.stud_sex) D, (a.fR_jochi) E,
(a.sokyun) F,(a.fR_doctor) G, (c.sec2_sokyun) H
from Fir1Result2002 a
Left outer join student b
on a.fRes1_jumin=b.stud_jumin
left outer join Fir2Result2002 c on
a.fRes1_code=c.sec2_code and c.sec2_code=(
select (d.sec2_code) from Fir2Result2002 d
where c.sec2_jumin=d.sec2_jumin and d.sec2_code like "011%"
and (d.sec2_gubun="C" or d.sec2_gubun="D2") )
where a.fR_jung="R" and a.fRes1_code like "011%"
제발 답변 좀 해주세요!