Question about an insert query

Hi, I have an insert query, and the problem is the subquery in the where statement at the end produces more than one record. Is it possible to do an insert for each of those links in the sub-query without using PL/SQL?
(I'm using Oracle 7.3.4 )

INSERT INTO tablea
(field1, field2, field3)

SELECT
(field1, field2, field3

FROM tableb
WHERE
  tableb.linkfield = (SELECT linkfield from tablec where tablealink = 1)

Thanks in advance,

Steven H. Received on Mon May 24 1999 - 06:09:33 CDT