lamjoun Wed, 03 Dec 2003 11:08:40 -0800
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'); thanks