mybatis中写sqlserver报错

发布于:2023-10-25 ⋅ 阅读:(63) ⋅ 点赞:(0)

查询语句中包含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