Reading from one table directly into another

[Jacob]

Is there a way to get a row from one table and write it directly into
another table? Most of the columns are named the same, but their are a few
that need to be ignored in the source table and a few which must be filled
in through user-entered values in the second table. Any links or code
examples would be great.

Thanks in advance,
Jacob

[Ray at]

select into

Here's the first link that comes up in Google.
[url]http://www.devguru.com/Technologies/jetsql/quickref/select_into.html[/url]

Ray at work

"Jacob" <yak2016@comcast.net> wrote in message
news:u3LKqE$PDHA.4024@tk2msftngp13.phx.gbl...

> Is there a way to get a row from one table and write it directly into
> another table? Most of the columns are named the same, but their are a

few

> that need to be ignored in the source table and a few which must be filled
> in through user-entered values in the second table. Any links or code
> examples would be great.
>
> Thanks in advance,
> Jacob
>
>

[Bob Barrows]

Jacob wrote:

> Is there a way to get a row from one table and write it directly into
> another table? Most of the columns are named the same, but their are
> a few that need to be ignored in the source table and a few which
> must be filled in through user-entered values in the second table.
> Any links or code examples would be great.
>
> Thanks in advance,
> Jacob

Well, this will vary from database to database in minor ways, but basically:
insert into table1(col1,col2, ... colN)
select col1,col2, ... colN FROM table2
WHERE <filter criteria>

Bob Barrows