回答編集履歴
1
修正
answer
CHANGED
|
@@ -23,7 +23,7 @@
|
|
|
23
23
|
```sql
|
|
24
24
|
SELECT
|
|
25
25
|
SUM((X.Total2 - B.Use)
|
|
26
|
-
* (case when A.PartsNo IS NOT and NULL B.Convert IS NOT NULL then 1 else B.Convert)
|
|
26
|
+
* (case when A.PartsNo IS NOT and NULL B.Convert IS NOT NULL then 1 else B.Convert end)
|
|
27
27
|
)
|
|
28
28
|
FROM …以下省略
|
|
29
29
|
cross apply (
|