alter table owereportmx add boilerid varchar(6) null
alter table owereportmx2 add boilerid varchar(6) null
alter table owereportmx add comein1 varchar(20) null
alter table owereportmx add comein1_zt char(1) null
alter table owereportmx2 add comein1 varchar(20) null
alter table owereportmx2 add comein1_zt char(1) null
update b set b.feemodel=f.boiler from Building b left outer join boiler f on LEFT(b.BuildingId,2)=RIGHT(f.boilerid,2)
update o set o.feemodel=b.feemodel from owner o left outer join Building b on left(o.roomId,6)=b.BuildingId
update mx set mx.boiler=b.feemodel from owereportmx mx left outer join Building b on left(mx.roomId,6)=b.BuildingId
update o set o.feemodel=b.feemodel from owner2 o left outer join Building b on left(o.roomId,6)=b.BuildingId
update mx set mx.boiler=b.feemodel from owereportmx2 mx left outer join Building b on left(mx.roomId,6)=b.BuildingId
update mx set mx.boilerid=b.boilerid from owereportmx mx left outer join boiler b on mx.boiler=b.boiler
update mx set mx.boilerid=b.boilerid from owereportmx2 mx left outer join boiler b on mx.boiler=b.boiler