摘要：
如果数据源是MsSql，则别名用[]括起来。如：SELECT s.id as [ID],realname as [学生名字],workplacename as [校区],w.id as [校区ID],companyid as [分公司ID],s.create_time as [发生时间] from students sleft join offices o on s.currentplace=o.IDleft join workplaces w on o.workplaceid=w.idwhere w.id in ('86')order by w.id,s.create_tim 阅读全文