On Wed, 2003-12-03 at 09:22, lamjoun wrote: > I have a problem with this request. > > insert into table month_var (year,month,var_cd,val) select > '2003','10',var_cd,0 from var and > var_cd not in (select var_cd from pers_var where year='2003' and > month='10'); > > after execution I have this error > > [Mysql][ODBC 3.51 Driver][mysqld-4.1.0-alpha-max-nt] you can't specify > target table 'month_var' for update in from clause.
Is your query correctly pasted ? insert into table month_var (year,month,var_cd,val) select '2003','10',var_cd,0 from var and var_cd not in (select var_cd from pers_var where year='2003' and month='10'); Look at: from var and var_cd not in supposed to be: from var where var_cd not in -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]