回答編集履歴
1
値を修正(null→0)
test
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
|
|
17
17
|
,COUNT(ITEMCODE) AS ITEM1
|
|
18
18
|
|
|
19
|
-
,
|
|
19
|
+
,0 AS ITEM2
|
|
20
20
|
|
|
21
21
|
FROM SHOPINFO
|
|
22
22
|
|
|
@@ -32,7 +32,7 @@
|
|
|
32
32
|
|
|
33
33
|
SELECT SHOPCODE AS SHOP
|
|
34
34
|
|
|
35
|
-
,
|
|
35
|
+
,0 AS ITEM1
|
|
36
36
|
|
|
37
37
|
,COUNT(ITEMCODE) AS ITEM2
|
|
38
38
|
|