[SQL ] 刪除重覆的資料
請問各位高手~
我用access
table有 sale 和 overlap
兩個table的欄位皆有c_id,product,s_date
我想刪除sale和overlap裡有重覆的資料
我下的query:
SELECT sale.c_id,sale.product,sale.s_date
FROM sale,overlap
WHERE sale.c_id <> overlap.c_id AND sale.product <> overlap.product
AND sale.s_date <> overlap.s_date
GROUP BY sale.c_id,sale.product,sale.s_date;
出來的data和sale完全一樣= =
根本沒刪除到overlap記錄的資料...
請問是哪裡出錯了?
懇請大家指教~
謝謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.115.228.10
→
11/26 00:50, , 1F
11/26 00:50, 1F
→
11/26 09:05, , 2F
11/26 09:05, 2F
推
11/26 12:14, , 3F
11/26 12:14, 3F
→
11/27 18:26, , 4F
11/27 18:26, 4F
→
11/28 00:30, , 5F
11/28 00:30, 5F
→
12/08 00:18, , 6F
12/08 00:18, 6F
討論串 (同標題文章)
Database 近期熱門文章
PTT數位生活區 即時熱門文章
