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