Fw: mysql request problem.

[lamjoun]

----- Original Message ----- 
From: lamjoun 
To: ListSearch@stripped 
Sent: Monday, December 01, 2003 2:31 PM
Subject: mysql request problem.


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


My configuration is

windows XP pro, Mysql-4.1-alpha.

Question

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

Thank you .