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 -> Help, please

Help, please

From: Gennady <gennadyb_at_halcosoftware.com>
Date: Fri, 3 Sep 1999 16:12:55 -0700
Message-ID: <37d0520b$0$19026@fountain.mindlink.net>


I am in complex SQL query process,
which consist of 3 steps:
1.
CREATE TABLE KEY.TEST AS
SELECT KEY.LumberSizes.LineNo, KEY.LumberSizes.LbrGroup, KEY.LumberSizes.LbrSize,
KEY.LumberLengths.LbrLength
FROM KEY.LumberSizes, KEY.LumberLengths WHERE
KEY.LumberSizes.LbrGroup = KEY.LumberLengths.LbrGroup
;

2.
CREATE TABLE RUN1.TEST AS
SELECT KEY.Test.LineNo, KEY.Test.LbrGroup, KEY.Test.LbrSize, KEY.Test.LbrLength, RUN1.RoughLumberValues.Value FROM KEY.Test, RUN1.RoughLumberValues
WHERE

KEY.Test.LbrGroup  = RUN1.RoughLumberValues.LbrGroup (+) AND
KEY.Test.LbrSize  = RUN1.RoughLumberValues.LbrSize (+) AND
KEY.Test.LbrLength  = RUN1.RoughLumberValues.LbrLength(+)

;

3.
SELECT RUN1.Test.LbrGroup, RUN1.Test.LbrSize, RUN1.Test.LbrLength, RUN1.Test.Value AS Value1, RUN2.RoughLumberValues.Value AS Value2
FROM RUN1.Test, RUN2.RoughLumberValues
WHERE
RUN1.Test.LbrGroup  = RUN2.RoughLumberValues.LbrGroup (+) AND
RUN1.Test.LbrSize  = RUN2.RoughLumberValues.LbrSize (+) AND
RUN1.Test.LbrLength  = RUN2.RoughLumberValues.LbrLength (+)
ORDER BY RUN1.Test.LineNo, RUN1.Test.LbrLength
;

All this steps are working OK.
Now I'd like to unite all 3 steps in one query like:

SELECT b.LbrGroup, b.LbrSize, b.LbrLength, b.Value AS Value1, RUN2.RoughLumberValues.Value AS Value2
FROM
SELECT a.LineNo, a.LbrGroup, a.LbrSize, a.LbrLength, RUN1.RoughLumberValues.Value
FROM
SELECT KEY.LumberSizes.LineNo, KEY.LumberSizes.LbrGroup, KEY.LumberSizes.LbrSize,
KEY.LumberLengths.LbrLength
FROM
KEY.LumberSizes, KEY.LumberLengths
WHERE
KEY.LumberSizes.LbrGroup = KEY.LumberLengths.LbrGroup a, RUN1.RoughLumberValues
WHERE

a.LbrGroup = RUN1.RoughLumberValues.LbrGroup (+) AND
a.LbrSize = RUN1.RoughLumberValues.LbrSize (+) AND
a.LbrLength = RUN1.RoughLumberValues.LbrLength (+) b, RUN2.RoughLumberValues
WHERE
b.LbrGroup = RUN2.RoughLumberValues.LbrGroup (+) AND
b.LbrSize = RUN2.RoughLumberValues.LbrSize (+) AND
b.LbrLength = RUN2.RoughLumberValues.LbrLength (+)
ORDER BY b.LineNo, b.LbrLength
;

But I 'v got an error : ORA-00903:invalid table name. Please, help me to fix this problem.
Thanks,
Gennady Received on Fri Sep 03 1999 - 18:12:55 CDT

Original text of this message

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