不好意思,前面的不清楚
select
room.id as id ,
room.roomid as roomid ,
device.wychargemeterdeviceid as bh ,
record.valuediff as actualvalue,
record.approtion asapprotion,record.value as value ,
record.meterdevicerecordid as meterdevicerecordid ,
device.chargemeterdeviceid as chargemeterdeviceid ,
device.beishu as bs ,
param.lowdegree,
param.firstrange,
param.secondrange,
param.thirdrange,
param.neededcalculatefee ,
param.normalprice,
param.firstrangeprice,
param.secondrangeprice,
param.thirdrangeprice ,
record.addvalue as addvalue
from
wy_room as room
inner join jf_chargemeterdevice as device using(id)
inner join jf_chargemeterparam as param using (chargemeterparamid)
left join jf_chargemeterdevicerecord as record
on (device.chargemeterdeviceid=record.chargemeterdeviceid
and param.chargemeterparamid = record.chargemeterparamid )
left join jf_calculaterecord as cal using (calserial)
where
room.buildingareaid='0613021207_1000000000000002462'
and room.buildingid='0724044445_1000000000000031287'
and device.type='电表'
and cal.calserial ='0918094046_1000000000000053836'
order by
room.roomid高手救救我。
select
room.id as id ,
room.roomid as roomid ,
device.wychargemeterdeviceid as bh ,
record.valuediff as actualvalue,
record.approtion asapprotion,record.value as value ,
record.meterdevicerecordid as meterdevicerecordid ,
device.chargemeterdeviceid as chargemeterdeviceid ,
device.beishu as bs ,
param.lowdegree,
param.firstrange,
param.secondrange,
param.thirdrange,
param.neededcalculatefee ,
param.normalprice,
param.firstrangeprice,
param.secondrangeprice,
param.thirdrangeprice ,
record.addvalue as addvalue
from
wy_room as room
inner join jf_chargemeterdevice as device using(id)
inner join jf_chargemeterparam as param using (chargemeterparamid)
left join jf_chargemeterdevicerecord as record
on (device.chargemeterdeviceid=record.chargemeterdeviceid
and param.chargemeterparamid = record.chargemeterparamid )
left join jf_calculaterecord as cal using (calserial)
where
room.buildingareaid='0613021207_1000000000000002462'
and room.buildingid='0724044445_1000000000000031287'
and device.type='电表'
and cal.calserial ='0918094046_1000000000000053836'
order by
room.roomid高手救救我。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货