Hi,

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 month_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.

My configuration is

windows XP pro, Mysql-4.1-alpha.

Question

This problem can be resolved with the next version of mysql ?

Thank you .