select into question

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 Received on Sat Oct 16 1999 - 13:53:26 CDT