回答編集履歴
1
修正
test
CHANGED
|
@@ -48,7 +48,7 @@
|
|
|
48
48
|
|
|
49
49
|
SUM((X.Total2 - B.Use)
|
|
50
50
|
|
|
51
|
-
* (case when A.PartsNo IS NOT and NULL B.Convert IS NOT NULL then 1 else B.Convert)
|
|
51
|
+
* (case when A.PartsNo IS NOT and NULL B.Convert IS NOT NULL then 1 else B.Convert end)
|
|
52
52
|
|
|
53
53
|
)
|
|
54
54
|
|