SELECT DISTINCT CHL_CHECK,
CHL_PART,
CHL_STORE,
CHL_BIN,
CHE_TYPE,
TO_CHAR(CHE_DATE, 'YYYY-MM-DD') CHE_ENDDATE
FROM REPAIR_CHECKLINES SKL, REPAIR_CHECK STK
WHERE CHL_DATE BETWEEN TO_DATE('2008-11-5', 'yyyy-mm-dd') AND
TO_DATE('2008-12-5', 'yyyy-mm-dd')
AND STK.CHE_CODE = SKL.CHL_CHECK 这样写后查出来的数据CHL_CHECK字段还是用重复的!!
CHL_PART,
CHL_STORE,
CHL_BIN,
CHE_TYPE,
TO_CHAR(CHE_DATE, 'YYYY-MM-DD') CHE_ENDDATE
FROM REPAIR_CHECKLINES SKL, REPAIR_CHECK STK
WHERE CHL_DATE BETWEEN TO_DATE('2008-11-5', 'yyyy-mm-dd') AND
TO_DATE('2008-12-5', 'yyyy-mm-dd')
AND STK.CHE_CODE = SKL.CHL_CHECK 这样写后查出来的数据CHL_CHECK字段还是用重复的!!
CHL_PART,
CHL_STORE,
CHL_BIN,
CHE_TYPE,
TO_CHAR(CHE_DATE, 'YYYY-MM-DD') CHE_ENDDATEdistinct是让这几个字段合在一起不会重复