求助 1054 - Unknown column '*' in 'where clause'的问题

Question

1054，Unknown column，where clause

Answer 1

没有这种写法你可以通过临时表或者存储过程先查询出满足连接关系的结果，再insert

Answer 2

INSERT INTO amount_compare (custom_count_20140630,amount_20140630,rate_20140630) select custom_count as custom_count_20140630,amount as amount_20140630,rate as rate_20140630 from amount_20140630,amount_compare where amount_compare.ibk_name=amount_20140630.ibk_name;

Answer 3

感觉楼主是在执行一个这样的操作 ：将 amount_compare 与 amount_20140630 的关联结果 插入到  amount_compare 表 ，根据理解意思，完善后的SQL脚本如下 ：
  INSERT INTO amount_compare (custom_count_20140630,amount_20140630,rate_20140630) select customset.custom_count_20140630, customset.amount_20140630 ,customset.rate_20140630   from  ( select custom_count as custom_count_20140630,amount as amount_20140630,rate as rate_20140630 from amount_20140630 where amount_compare.ibk_name=amount_20140630.ibk_name ) as customset;