Re: select into question

Charles L Wilson schrieb:

> I need to know how to select into a table from a table join. All tables are
> in the same table space.
>
> tables
> order_item: the one to be filled with info
> cart_item: contains contents of shopping cart
> product: extra info about each item
>
> some thing like
>
> select into order_item(order_id,product_id,
> name,date_created,quantity,price)
> values
> ( select nextOrder_id ,c.product_id,p.name,SYSDATE,c.quantity, p.price
> from product p, cart_item c
> where p.product_id = c.product_id
> and c.cart_id = cart_id)
>
> I need some sort of example to copy
>
> All help appreciated
>
> Charles

Hi, try following

INSERT table
SELECT * FROM other_table

Just put the 'insert table' before your datasource.

Milo Received on Sat Oct 16 1999 - 14:54:49 CDT