问答交流

【代码报错】BinderException: Binder Error: Ambiguous reference to column name "close"

由liyajuan57创建,最终由small_q 被浏览 9 用户

"close" (use: "cn_stock_prefactors.close" or "cn_stock_bar1d.close")

==close / m_lag(close,6)==

close / m_lag(close,11)

close / m_lag(close,41)

m_avg(turn\*100, 6 )

m_avg(turn\*100, 11 )

m_avg(turn\*100, 21 )

m_avg(turn\*100, 6 )/(turn\*100)

==m_ta_rsi(cn_stock_bar1d.close, 14)==

roe_avg_lf

net_profit_to_parent_shareholders_lf

c_pct_rank(m_stddev((high-close)/close,5))


==BinderException: Binder Error: Ambiguous reference to column name "close" (use: "cn_stock_prefactors.close" or "cn_stock_bar1d.close")==

评论
  • SQL语法问题,因为:cn_stock_prefactors 和 cn_stock_bar1d 中都有 close 字段,当你使用时需要指明该字段来自哪个字表
{link}