Re: Fw: mysql request problem.

2003-12-03 Thread lamjoun
ssage - From: "Diana Soares" <[EMAIL PROTECTED]> To: "lamjoun" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 03, 2003 4:42 PM Subject: Re: Fw: mysql request problem. > On Wed, 2003-12-03 at 09:22, lamjoun wrote: > > I have

Re: Fw: mysql request problem.

2003-12-03 Thread Diana Soares
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 e

Fw: mysql request problem.

2003-12-03 Thread lamjoun
- 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 (selec