Re: SQL insert using select

[Aaron Abreu <abreual@xxxxxxxxxxxxx>]

maybe I'm oversimplyfying the task,
sure sounds to easy

after you insert the new records

update myfile
set clientnumber = 'x'
where clientnumber = 'n'




On Thu, Jul 19, 2012 at 8:39 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

> Hi,
> I need to do this on a bunch of files :
>
> insert into myfile
> select *from myotherfile where clientnumber = 'n'
>
> problem is, I want to set the clientnumber that is written to myfile to
> 'x'.
>
> Possible?
> --
> 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.