update c set c.isreserve = (case when a.reserve_time>getdate() and a.arrive_time isnull and a.iscancel=0 then 1 else 0 end),
c.istaboo = (case when b.end_time > getdate() then 1 else 0 end)
from room c
left join reserve a on a.room_id = c.room_id
left join taboo b on b.room_id = c.room_id
c.istaboo = (case when b.end_time > getdate() then 1 else 0 end)
from room c
left join reserve a on a.room_id = c.room_id
left join taboo b on b.room_id = c.room_id
istaboo=case when exists(select 1 from taboo where end_time>getdate()) then 1 else 0 end??
istaboo=case when exists(select 1 from taboo where end_time>getdate() and taboo.room_id=room.room_id) then 1 else 0 end