查询语句中包含User,是系统字段需要加符号,[]也报错,""加双引号才成功:
select m.*,
u.unitName as szUnitName,
u1.unitName as ypUnitName,
yc.className as ypSortName,
le.sortName as leeSortName,
cc.costName as fyglName,
og.gName as yljbName,
tr.Name as zlfwName,
us.userName as userName
from Medicine m
left join Unit u on m.szUnit = u.id
left join Unit u1 on m.ypUnit = u1.id
left join YpClass yc on m.ypSort = yc.id
left join LeechdomSort le on m.leeSortID = le.id
left join CostClass cc on m.fygl = cc.id
left join OrganGrade og on m.yljb = og.id
left join TreatRange tr on m.zlfw = tr.id
left join "User" us on m.userID = us.id