请朋友友帮小弟我看看这句，哪里有有关问题
日期：2014-05-17 浏览次数：20547 次
请朋友友帮我看看这句，哪里有问题？
运行提示：‘.’附近有语法错误！
------解决方案--------------------
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
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
