Re: SQL INSERT

["Keith Carpenter" <CarpCon@xxxxxxx>]

Specify the fields for insert and use the subselect format.  Select the
fields along with the constants to match the insert file fields.  For
example:

INSERT INTO somefile (field1, field2, field3)
 SELECT  column1, column2, 'VALUEX' FROM anotherfile



----- Original Message ----- 
From: <michaelr_41@xxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, April 01, 2004 6:39 AM
Subject: SQL INSERT


> Pardon my lameness, but how would one insert rows into a table using a
> combination of a subselect and values? I want to insert a row(s) where
> some columns would be filled by a select of another table, and other
> columns in the same row would be literal values. Also, how does this lame
> one insert only a few columns in a table from a subselect? In other
> words, I want to put the value in the third column of the selected table
> into the first column of the target table. Can you specify totable.column
> = fromtable.column?
>
> TIA...
> -- 
>
>   michaelr_41@xxxxxxxxxxxxxx
>
> -- 
> http://www.fastmail.fm - Does exactly what it says on the tin
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>