7-11
一般會員
發表:53 回覆:33 積分:16 註冊:2005-12-05
發送簡訊給我
|
SELECT OIL_CK8.*, (CASE OIL_CK8.TYPE WHEN 'Y' THEN '贈品' ELSE '販售' End) as CTYPE, (CASE OIL_CK8.CNUM WHEN '05' THEN '九五' WHEN '02' THEN '九二' WHEN '03' THEN '九八' WHEN '04' THEN '柴油' END) AS SNUM, STNNAME1 = (SELECT NAME FROM STATION WHERE STNID = OIL_CK8.STNID), STNNAME2 = (SELECT NAME FROM STATION WHERE STNID = OIL_CK8.STNID2), REMARK2 = (SELECT REMARK2 FROM OIL_CK7 WHERE SQID < SubString(OIL_CK8.QID,1,7) AND EQID > SubString(OIL_CK8.QID,1,7) AND MONEY = SubString(OIL_CK8.QID,8,4)) FROM OIL_CK8,STATION WHERE OIL_CK8.STNID = 'BJG023' AND OIL_CK8.PDATE2='20060718'
為何我這段語法所查詢出來的每個值會重複30筆
例: 000112345678 重複了30次
000112555678 又重複了30次
|
pedro
尊榮會員
發表:152 回覆:1187 積分:892 註冊:2002-06-12
發送簡訊給我
|
應該資料確實有那麼多筆,只是您組資料時,碰巧組成雷同的字串,
或許可以在此條件多限定一些
>WHERE OIL_CK8.STNID = 'BJG023' AND OIL_CK8.PDATE2='20060718'
|
7-11
一般會員
發表:53 回覆:33 積分:16 註冊:2005-12-05
發送簡訊給我
|
資料我非常肯定只有 22筆 所以才會頭痛
嗚~神阿救救我ㄚ~差這部分報表就完成了~要帶女朋友出去玩說~ >_<"
===================引 用 文 章===================
應該資料確實有那麼多筆,只是您組資料時,碰巧組成雷同的字串,
或許可以在此條件多限定一些
>WHERE OIL_CK8.STNID = 'BJG023' AND OIL_CK8.PDATE2='20060718'
|
pedro
尊榮會員
發表:152 回覆:1187 積分:892 註冊:2002-06-12
發送簡訊給我
|
這兩個Table的Join條件,沒看到在Where後有限制
>FROM OIL_CK8,STATION
|
7-11
一般會員
發表:53 回覆:33 積分:16 註冊:2005-12-05
發送簡訊給我
|
謝謝喔~改成這樣就好了!
SELECT OIL_CK8.*, (CASE OIL_CK8.TYPE WHEN 'Y' THEN '贈品' ELSE '販售' End) as CTYPE, (CASE OIL_CK8.CNUM WHEN '05' THEN '九五' WHEN '02' THEN '九二' WHEN '03' THEN '九八' WHEN '04' THEN '柴油' END) AS SNUM, STNNAME1 = (SELECT NAME FROM STATION WHERE STNID = OIL_CK8.STNID), STNNAME2 = (SELECT NAME FROM STATION WHERE STNID = OIL_CK8.STNID2), REMARK2 = (SELECT REMARK2 FROM OIL_CK7 WHERE SQID < SubString(OIL_CK8.QID,1,7) AND EQID > SubString(OIL_CK8.QID,1,7) AND MONEY = SubString(OIL_CK8.QID,8,4)) FROM OIL_CK8,STATION WHERE OIL_CK8.STNID = 'BJG023' AND OIL_CK8.PDATE2='20060718'
---->FROM OIL_CK8,STATION WHERE OIL_CK8.STNID = 'BJG023' AND OIL_CK8.STNID = STATION.STNID AND OIL_CK8.PDATE2='20060718' ===================引 用 文 章===================
這兩個Table的Join條件,沒看到在Where後有限制
>FROM OIL_CK8,STATION
|