|
kabe さん、こん**は。Hidemi Oya です。
列数固定クロス表は、下記のような感じでサブクエリ無し集約関数のみで実装できそうです。ただし、[#218] と違って、何故か else 節を NULL にするとうまく表示できません。
select Syurui, Meisyo, Jiki, Kaisu,
max(case Byogai when "べと病" then "●" else "" end) as beto,
max(case Byogai when "灰色かび病" then "●" else "" end) as haikabi,
max(case Byogai when "うどんこ病" then "●" else "" end) as udonko,
max(case Byogai when "斑点細菌病" then "●" else "" end) as hanten,
max(case Byogai when "褐斑病" then "●" else "" end) as kappan,
max(case Byogai when "菌核病" then "●" else "" end) as kinkaku
from tekiyou where Sakumotu like "きゅうり%" and
(Byogai = "べと病" or Byogai = "灰色かび病" or Byogai = "うどんこ病" or Byogai = "斑点細菌病" or Byogai = "褐斑病" or Byogai = "菌核病")
group by Meisyo
|
|