| |
ACFinder で、展着剤の製剤としての効果が空白になっています。m_kihon 作成時の最終段階を下記のように変更してください。
CREATE TABLE m_kihon AS
SELECT
bango, shurui, meisho, tsusho, ryakusho, kongo, yoto, zaikei,
--idkoka,
CASE WHEN kokaid = 0 AND shurui LIKE '%展着剤'
THEN '展着'
ELSE
concat('・',
(select koka from koka where kokaid = idkoka & 3),
(select koka from koka where kokaid = idkoka & 4),
(select koka from koka where kokaid = idkoka & 8),
(select koka from koka where kokaid = idkoka & 16),
(select koka from koka where kokaid = idkoka & 32),
(select koka from koka where kokaid = idkoka & 64),
(select koka from koka where kokaid = idkoka & 128),
(select koka from koka where kokaid = idkoka & 256),
(select koka from koka where kokaid = idkoka & 512),
(select koka from koka where kokaid = idkoka & 1024),
(select koka from koka where kokaid = idkoka & 2048),
(select koka from koka where kokaid = idkoka & 4096),
(select koka from koka where kokaid = idkoka & 8192),
(select koka from koka where kokaid = idkoka & 16384),
(select koka from koka where kokaid = idkoka & 32768)
)
END AS koka,
seibun1, keito1, --koka1,
seibun2, keito2, --koka2,
seibun3, keito3, --koka3,
seibun4, keito4, --koka4,
seibun5, keito5 --, koka5
FROM t_kihon2;
|
|
