2011年5月11日
第一次使用Excel2007的Microsoft Query遇到的问题及解决：别名的使用
摘要： 如果数据源是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 阅读全文
posted @ 2011-05-11 12:53 thomaswang 阅读(782) 评论(0) 推荐(0)