RE: SQL INSERT

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

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.