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
|
發表時間：2006-08-01 17:14:25
IP:220.130.xxx.xxx 未訂閱
