RE: SQL INSERT

[michaelr_41@xxxxxxxxxxxxxx]

Thanks...

On Thu, 1 Apr 2004 09:06:10 -0600, "DeLong, Eric"
<EDeLong@xxxxxxxxxxxxxxx> said:
> Ignore the insert part for now and just devise a SELECT that produces the
> data that you want.  Use UNION to append multiple SELECTs together if you
> need.  Once you have a means of producing your new records, take your SQL
> statement and simply prefix it with INSERT INTO library/file ...
> 
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-898-7863 or ext. 1863
> 
> 
> 
> -----Original Message-----
> From: michaelr_41@xxxxxxxxxxxxxx [mailto:michaelr_41@xxxxxxxxxxxxxx]
> Sent: Thursday, April 01, 2004 8:40 AM
> To: Midrange Systems Technical Discussion
> 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 - Does exactly what it says on the tin