Re: trouble with insert

From: Maxim Demenko <>
Date: Sun, 13 Jul 2008 15:28:11 +0200
Message-ID: <g5cvte$1ob$00$>

sheldonlg schrieb:
> This should be so simple, yet it is not working. I am trying to do an
> insert into a table where the values inserted are gathered from a select
> from another table. This form works:
> insert into table2 (select fld1, fld2, fld3 from table1 where blah)
> However, I do not want to be dependent upon the order of the fields in
> table2 so, I tried this:
> insert into table2 (fld1, fld2, fld3) values(
> select fld1, fld2, fld3 from table1 where blah)
> )
> This gave me a not enough values error coming from the first set of
> parentheses. I don't understand that error. It should not care how
> many fields are inserted, so long as the two sets match. Also, in this
> case, all the fields of table2 are named.

Just remove surrounding values() clause from your select.

The syntax for insert ... select is documented here:
(Inserting values with a subquery example)

Best regards

Maxim Received on Sun Jul 13 2008 - 08:28:11 CDT

Original text of this message