Hi Alan,

You have appended records. I thought you wanted to
modify some column in existing records from a column
of another table.

Dev

--- Alan Grobert <alangrobert@h...> wrote:
> Actually the answer is much simpler, i.e.,
> 
> INSERT INTO tablename (field, field, etc...) SELECT
> field, field, etc... 
> FROM sourcetablename
> 
> LIke so. I found the answer in one of my many books.
> 
> 
> >From: "Samratchana List" <samratchana@y...>
> >Reply-To: "sql language"
> <sql_language@p...>
> >To: "sql language" <sql_language@p...>
> >Subject: [sql_language] Re: copy table column
> >Date: Wed, 1 Nov 2000 16:32:09 +0530
> >
> >Hi Alan,
> >
> >     There should be some relationship between
> Table A & Table B. Only then 
> >copying is meaningful. And the no of records should
> match (or a unique id 
> >should be there to conditionally copy records)
> >
> >Dev
> >   ----- Original Message -----
> >   From: Alan Grobert
> >   To: sql language
> >   Sent: Wednesday, November 01, 2000 4:20 AM
> >   Subject: [sql_language] copy table column
> >
> >
> >   If I have a table with 2 columns, table B, how
> can I copy
> >   a column from another table, table A, into a
> column in
> >   table B?
> >
> >   Alan
> >
> >