kooker

SELECT m.dataId, m.ipm_code, m.ipcc_code, m.bill_code, m.bill_name, m.ipqb_unit,
m.ipmd_qty, p.ipqb_price,
(case  
when m.ipao_code is null or m.ipao_code='' then m.ipmd_qty * p.ipqb_price
else
  case when a.mp_type=0 then  m.ipmd_qty * p.ipqb_price
   else
    case when a.mp_price_type=0 then
      (m.ipmd_qty-m.ipmd_alteration_qty)*p.ipqb_price
      +m.ipmd_alteration_qty*a.ipab_price_new
     else
      (m.ipmd_qty-m.ipmd_alteration_qty)*(a.ipab_price_new-p.ipqb_price)
      +m.ipmd_alteration_qty*a.ipab_price_new
    end
  end
end )  as amount
FROM Measure_Data AS m
INNER JOIN pro_Bill AS p ON m.bill_code = p.bill_code
left JOIN alteration_bill a on m.ipao_code=a.ipao_code and m.bill_code=a.bill_code
inner join measure_baseinfo mb on m.ipm_code=mb.ipm_code
WHERE (m.ipcc_code = 'N0123') and mb.mpflow_result=2

这里视图里的SQL,对字段进行绑定,提示主视图找不到对应的影射表名和字段名
哪位能帮忙解决一下,万分感谢

crackso

使用新版本试试。

如果是定义字段，列表里没显示的话，可以直接输入字段去定义。