----- Original Message ----- From: lamjoun To: [EMAIL PROTECTED] 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 .