Re: Compound INSERT statement - easy (I think)

In article <dolans.899929499_at_stripe.Colorado.EDU>, dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:
> All I am trying to do is insert a new record into a table using the
> data from another table. The query is below but won;t work... can someone
> help, please.
>
>insert into knowledge(id, product_id, short_prob, long_prob,
>short_solu, long_solu, steps) values(knowledge_seq.nextval, (
>select ik.product_id, ik.short_prob, ik.long_prob, ik.short_solu,
>ik.long_solu, ik.steps from shhd_owner.inc_to_knowledge ik where
>ik.id=24));
>
>Thanks,
>Sean

insert into knowledge(id, product_id, short_prob, long_prob, short_solu, long_solu, steps)
(select knowledge_seq.nextval, ik.product_id, ik.short_prob, ik.long_prob,

ik.short_solu, 
ik.long_solu, ik.steps from shhd_owner.inc_to_knowledge ik where 
ik.id=24);

Wessel van Alphen

(Please remove X's from e-mail account when replying) Received on Thu Jul 09 1998 - 01:16:45 CDT