请朋友友帮小弟我看看这句,哪里有有关问题
请朋友友帮我看看这句,哪里有问题?
运行提示:‘.’附近有语法错误!
------解决方案--------------------
SELECT xiadan_ls.ID ,
xiadan_ls.KCID ,
xiadan_ls.DJBID ,
xiadan_ls.GoodsName ,
xiadan_ls.SpecType ,
xiadan_ls.Provider ,
xiadan_ls.remarks_xd ,
xiadan_ls.Assort ,
xiadan_ls.Quantity_xd ,
xiadan_ls.Unit ,
ISNULL(xiadan_ls.UnitPrice, 0) AS [xiadan_ls.UnitPrice] ,
xiadan_ls.Time ,
Storage_kc.Quantity
FROM xiadan_ls
LEFT JOIN Storage_kc ON xiadan_ls.KCID = Storage_kc.ID
------解决方案--------------------
select xiadan_ls.ID,xiadan_ls.KCID,xiadan_ls.DJBID,xiadan_ls.GoodsName,xiadan_ls.SpecType,xiadan_ls.Provider,xiadan_ls.remarks_xd,xiadan_ls.Assort,xiadan_ls.Quantity_xd,xiadan_ls.Unit,isnull(xiadan_ls.UnitPrice,0) as xiadan_ls.UnitPrice,xiadan_ls.Time,Storage_kc.Quantity from xiadan_ls left join Storage_kc on xiadan_ls.KCID=Storage_kc.ID
运行提示:‘.’附近有语法错误!
------解决方案--------------------
SELECT xiadan_ls.ID ,
xiadan_ls.KCID ,
xiadan_ls.DJBID ,
xiadan_ls.GoodsName ,
xiadan_ls.SpecType ,
xiadan_ls.Provider ,
xiadan_ls.remarks_xd ,
xiadan_ls.Assort ,
xiadan_ls.Quantity_xd ,
xiadan_ls.Unit ,
ISNULL(xiadan_ls.UnitPrice, 0) AS [xiadan_ls.UnitPrice] ,
xiadan_ls.Time ,
Storage_kc.Quantity
FROM xiadan_ls
LEFT JOIN Storage_kc ON xiadan_ls.KCID = Storage_kc.ID
------解决方案--------------------
select xiadan_ls.ID,xiadan_ls.KCID,xiadan_ls.DJBID,xiadan_ls.GoodsName,
xiadan_ls.SpecType,xiadan_ls.Provider,xiadan_ls.remarks_xd,xiadan_ls.Assort,
xiadan_ls.Quantity_xd,xiadan_ls.Unit,isnull(xiadan_ls.UnitPrice,0) as UnitPrice,
xiadan_ls.Time,Storage_kc.Quantity from xiadan_ls left join Storage_kc on xiadan_ls.KCID=Storage_kc.ID