CREATE VIEW hyqd as
select id,meetingid,userid,case when attendType=1 then ‘参会人员’ else ‘非参会人员’ end as chlx,
case when signTime IS null or signTime=’’ then ‘未签到’ else signTime end as qdsj,signReson,flag,longitude,latitude,signRemark
from Meeting_Sign
【泛微Ecology9 sql】 会议签到视图
最新推荐文章于 2023-06-08 15:04:01 发布