回答編集履歴
1
訂正
test
CHANGED
@@ -18,13 +18,13 @@
|
|
18
18
|
|
19
19
|
inner join (
|
20
20
|
|
21
|
-
select purchase_id, tem_cd, price
|
21
|
+
select purchase_id, item_cd, price
|
22
22
|
|
23
23
|
, max(id) as purchase_detail_id, count(*) as `個目`
|
24
24
|
|
25
25
|
from purchase_details
|
26
26
|
|
27
|
-
group by purchase_id, tem_cd, price
|
27
|
+
group by purchase_id, item_cd, price
|
28
28
|
|
29
29
|
) b
|
30
30
|
|