Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert with multiple subqueries question - Oracle9i

Re: Insert with multiple subqueries question - Oracle9i

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 14 Apr 2005 12:01:50 -0700
Message-ID: <1113505310.669381.202310@l41g2000cwc.googlegroups.com>

brent.de..._at_gmail.com wrote:
> I am having an issue trying to insert into a table, but i'm not sure
of
> the syntax or if it is even possible. I'm inserting into Table1,
which
> has a composite PK of 3 values, all of these PK's are FK's to other
> tables shown below:
>
> Table1: Table2: Table3:
> value1 PK value1 PK value3 PK
> value2 PK value2 PK
> value3 PK
> value4
> value5
>
> Is it possible to do something like this:
>
> INSERT INTO Table1(value1,value2,value3) ((SELECT value1,value2 FROM
> table2),(SELECT value3 from Table3));
>
> Again i'm not sure if this is the correct syntax or if this is
> possible, if someone could enlighten me on if this is possible and if
> they know a way to accomplish this, that'd be wonderful.
>
> Thanks in advance,
> Brent

Is there any link between Table2 and Table3? If not then how do you think you are going to map Table2 values to Table3 to be inserted into Table1?

Regards
/Raufw Received on Thu Apr 14 2005 - 14:01:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US