| |
うちの母ちゃんに依頼された実例です。なす、ピーマン、かぼちゃについては、（）無しと（露地栽培）のみということで、検索条件で全て列挙する方式です。
select yoto, shurui, tsusho,
max(case when sakumotsu like "なす%" then jiki||"、 "||kaisu else "" end) as nasu,
max(case when sakumotsu like "ﾋﾟｰﾏﾝ%" then jiki||"、 "||kaisu else "" end) as pman,
max(case when sakumotsu like "かぼちゃ%" then jiki||"、 "||kaisu else "" end) as kabocha,
max(case when sakumotsu = "にがうり" then jiki||"、 "||kaisu else "" end) as goya,
max(case when sakumotsu = "ｵｸﾗ" then jiki||"、 "||kaisu else "" end) as okura
from tekiyo where
(yoto like "殺虫%" or yoto like "%殺菌剤") and hoho = "散布" and shurui not like "%粉剤" and shurui not like "%粒剤" and
sakumotsu in ("なす", "なす（露地栽培）", "ﾋﾟｰﾏﾝ", "ﾋﾟｰﾏﾝ（露地栽培）", "かぼちゃ", "かぼちゃ（露地栽培）", "にがうり", "ｵｸﾗ")
group by tsusho order by yoto, shurui, tsusho
|
|
(06/06/11 8:46)
