select max(Switch1) as Swithch1,max(Switch2) as Swithch2,max(Switch3) as Switch3,
max(Switch4) as Switch4,max(Switch5) as Switch5,max(Switch6) as Switch6,
max(Switch7) as Switch7,max(Switch8) as Switch8,max(Switch9) as Switch9,
max(Switch10) as Switch10,max(Switch11) as Switch11,max(Switch12) as Switch12,
max(Switch13) as Switch13,max(Switch14) as Switch14,max(Switch15) as Switch15,
max(Switch16) as Switch16 from YF_SwitchInfo where ElevatorID=139
select count(case YF_HistoryData.flag
when 9 then 0 end)
as flag9,
count(case YF_HistoryData.flag
when 1 then 0 end)
as flag1,
count(case YF_HistoryData.flag
when 2 then 0 end)
as flag2,
count(case YF_HistoryData.flag
when 5 then 0 end)
as flag5,
count(case YF_HistoryData.flag
when 6 then 0 end)
as flag6,
count(case YF_HistoryData.flag
when 17 then 0 end)
as flag17,
count(case YF_HistoryData.flag
when 18 then 0 end)
as flag18,
count(case YF_HistoryData.flag
when 20 then 0 end)
as flag20,
count(case YF_HistoryData.flag
when 3 then 0 end)
as flag3,
count(case YF_HistoryData.flag
when 4 then 0 end)
as flag4,
count(case YF_HistoryData.flag
when 19 then 0 end)
as flag19
from YF_HistoryData where ElevatorID=139
两个SQL的查询达到了需求。但是如果写到一起复合查询的话就出问题了。
flag返回的不是我想要的。
那位能帮我写一下。
这两张表的关系是和一个YF_ElevatorInfo表的ElevatorID主外键关联的。
max(Switch4) as Switch4,max(Switch5) as Switch5,max(Switch6) as Switch6,
max(Switch7) as Switch7,max(Switch8) as Switch8,max(Switch9) as Switch9,
max(Switch10) as Switch10,max(Switch11) as Switch11,max(Switch12) as Switch12,
max(Switch13) as Switch13,max(Switch14) as Switch14,max(Switch15) as Switch15,
max(Switch16) as Switch16 from YF_SwitchInfo where ElevatorID=139
select count(case YF_HistoryData.flag
when 9 then 0 end)
as flag9,
count(case YF_HistoryData.flag
when 1 then 0 end)
as flag1,
count(case YF_HistoryData.flag
when 2 then 0 end)
as flag2,
count(case YF_HistoryData.flag
when 5 then 0 end)
as flag5,
count(case YF_HistoryData.flag
when 6 then 0 end)
as flag6,
count(case YF_HistoryData.flag
when 17 then 0 end)
as flag17,
count(case YF_HistoryData.flag
when 18 then 0 end)
as flag18,
count(case YF_HistoryData.flag
when 20 then 0 end)
as flag20,
count(case YF_HistoryData.flag
when 3 then 0 end)
as flag3,
count(case YF_HistoryData.flag
when 4 then 0 end)
as flag4,
count(case YF_HistoryData.flag
when 19 then 0 end)
as flag19
from YF_HistoryData where ElevatorID=139
两个SQL的查询达到了需求。但是如果写到一起复合查询的话就出问题了。
flag返回的不是我想要的。
那位能帮我写一下。
这两张表的关系是和一个YF_ElevatorInfo表的ElevatorID主外键关联的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货