求助 1054 - Unknown column '*' in 'where clause'的问题
想从第二张表中取值为第一张表的某些字段赋值,频频报1054错误,找不到字段名称,其中amount_compare,amount_20140630是两张表,ibk_name是两张表都拥有的字符型字段,具体代码如下,请帮忙看看。
数据库是mysql 5.6.19
mysql> 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 where amount_compare.ibk_name=amount_20140630.ibk_name;
1054 - Unknown column 'amount_compare.ibk_name' in 'where clause'