列前缀'b'与查询中所用的表名或别名不匹配selectd.DESKCODEdeskcode,a.PRICEprice,a.SIGNTIMEsignTime,a.REMARKremark,a.ADDDATEaddDate,a.DYNAMICNAMEdynamicName,b.FOODIDfoodId,b.FOODCODEfoodCode,b.FOODNAMEfoodName,c.FTNA

Question

列前缀 'b' 与查询中所用的表名或别名不匹配
select d.DESK_CODE deskcode,a.PRICE price,a.SIGN_TIME signTime,a.REMARK remark,a.ADD_DATE addDate,a.DYNAMIC_NAME dynamicName,
b.FOOD_ID foodId,b.FOOD_CODE foodCode,b.FOOD_NAME foodName,c.FT_NAME foodTypeName,sum(a.QTY) qty ,sum(a.AMT) amt
from MS_DCheckItem a
left join MS_DDESK d on (a.DESK_ID=d.DESK_ID)
left join MS_DFoodType c on(c.FT_ID=b.FOOD_TYPE)
left join MS_DFood b on (b.FOOD_ID=a.FOOD_ID)

Answer 1

在b表中查询的字段在b表中不存在,看看是不昌字段名写错了