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=3D'2003' and = month=3D'10');

after execution I have this error=20

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

You should test the above with 4.1.1 which is already out.

Sincerely,