Re: SQL INSERT

[michaelr_41@xxxxxxxxxxxxxx]

Cool...thank you.

On Thu, 1 Apr 2004 07:04:08 -0800, "Keith Carpenter" <CarpCon@xxxxxxx>
said:
> 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.
> >
> >
> 
> _______________________________________________
> 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.
> 
-- 
  
  michaelr_41@xxxxxxxxxxxxxx

-- 
http://www.fastmail.fm - IMAP accessible web-mail