From: lamjoun [mailto:[EMAIL PROTECTED]
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
This isn't a problem request to be resolved in the next versions. You're simply
using incorrect MySQL syntax.
Since you've now posted this three times with no further explanation of what you're
trying to get at, one can only assume you're trying to perform an INSERT INTO...SELECT
FROM that'd be helped by using a join of some sort.
If you're trying to limit it based on values found or not found in another table, as
it appears, try something like...
INSERT INTO month_var (year, month, var_cd, val)
SELECT '2003', '10', var.var_cd, '0' FROM var
LEFT JOIN month_var ON month_var.var_cd=var.var_cd
WHERE month_var.year='2003'
AND month_var.month='10'
AND month_var.var_cd IS NULL
I don't have your table structure and, actually, am not entirely sure of what you're
aiming for, so I don't know if that above query works. If not, try looking at the
manual.
INSERT...SELECT syntax
http://www.mysql.com/doc/en/INSERT_SELECT.html
JOIN syntax
http://www.mysql.com/doc/en/JOIN.html
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
