Question

求高手解答。SQL语句执行报错。

SELECT
a.OrderNo AS OrderItemNo,a.OrderItemNo AS OrderNo, a.CreateTime,D.AreaNo AS OrderCity, b.Status, b.ConsumeMerchant,1 AS Quantity, a.CommodityOriginPrice,a.CommodityOriginPrice AS OriginPrice, a.Price AS Amount,a.VendorNo,b.ExpenseValue,b.ValidateDate as PayTime, E.OriginPercent, CASE WHEN E.OriginPercent IS NULL THEN 0 ELSE b.ExpenseValue / E.OriginPercent END AS TicketPoint, b.VoucherNo
FROM control.tb_OrderDetails as a INNER JOIN
control.tb_Voucher as b ON a.VoucherNo = b.VoucherId LEFT OUTER JOIN
control.tb_Area AS D ON control.tb_Order.OrderCity = D.AreaNo LEFT OUTER JOIN
control.v_GetMerchantPriceTemplate AS E ON E.OrgCode = 'zhongying' AND a.VendorNo = E.PartnerNo
----------------------------------------------------------------------------------------------------------
执行后报错。
消息 4104，级别 16，状态 1，第 1 行
无法绑定由多个部分组成的标识符 "control.tb_Order.OrderCity"。

Answer 1

你的　别名表　D　对应的是control.tb_Area 。且为左联接，所以只能对应 别名为a,b的表字段相关联。
你在哪里出现 control.tb_Order表了？这个SQL里根本就没有这个表。你是不是少写表了。你自己再仔细看一下。

Answer 2

应该这样写吧
FROM control.tb_OrderDetails as a INNER JOIN
control.tb_Voucher as b LEFT OUTER JOIN
control.tb_Area AS D LEFT OUTER JOIN
control.v_GetMerchantPriceTemplate AS E
ON (a.VoucherNo = b.VoucherId
and control.tb_Order.OrderCity = D.AreaNo
and E.OrgCode = 'zhongying' AND a.VendorNo = E.PartnerNo)
你试试
tb_Order 这个表 好像没有写进来 在from后面没有它

Answer 3

FROM control.tb_OrderDetails as a INNER JOIN
control.tb_Voucher as b ON a.VoucherNo = b.VoucherId LEFT OUTER JOIN
control.tb_Area AS D ON control.tb_Order.OrderCity = D.AreaNo LEFT OUTER JOIN
你上面的control.tb_Order.OrderCity 这里出问题，你加多一个inner join control.tb_Order as X 之类的，不能直接这样用