回答編集履歴
4
推敲
test
CHANGED
|
@@ -1,6 +1,6 @@
|
|
|
1
1
|
テーブル[KANRI]はEAV構造ですね。
|
|
2
2
|
|
|
3
|
-
EAVの
|
|
3
|
+
EAVの識別を示す項目(k_kbn)を結合条件に含めます。
|
|
4
4
|
|
|
5
5
|
```SQL
|
|
6
6
|
|
3
推敲
test
CHANGED
|
@@ -14,7 +14,7 @@
|
|
|
14
14
|
|
|
15
15
|
and product.k_kbn = '0001'
|
|
16
16
|
|
|
17
|
-
left join KANRIas unit
|
|
17
|
+
left join KANRI as unit
|
|
18
18
|
|
|
19
19
|
on SHOHIN.s_tani = unit.k_key
|
|
20
20
|
|
2
修正
test
CHANGED
|
@@ -8,13 +8,13 @@
|
|
|
8
8
|
|
|
9
9
|
from SHOHIN
|
|
10
10
|
|
|
11
|
-
left join KANR as product
|
|
11
|
+
left join KANRI as product
|
|
12
12
|
|
|
13
13
|
on SHOHIN.s_shohin_cd = product.k_key
|
|
14
14
|
|
|
15
15
|
and product.k_kbn = '0001'
|
|
16
16
|
|
|
17
|
-
left join KANR
|
|
17
|
+
left join KANRIas unit
|
|
18
18
|
|
|
19
19
|
on SHOHIN.s_tani = unit.k_key
|
|
20
20
|
|
1
推敲
test
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
|
|
17
17
|
left join KANR as unit
|
|
18
18
|
|
|
19
|
-
on SHOHIN.s_tan
|
|
19
|
+
on SHOHIN.s_tani = unit.k_key
|
|
20
20
|
|
|
21
21
|
and unit.k_kbn = '0005'
|
|
22
22
|
|