Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Documentation for 8.*
Hello,
i've to optimize a sql statement for a customer. There are inner join and join.
Is there any documentation which I can read in order to know how to do it.
The statement from an mssql server doesn't work.
The Problem:
tab1:
id1
name1
tab2:
id2
name2
tab3:
id3
id1
id2
I need all name1s from tab1 which are empty. That means no id2 exist for id1.
The whole problem is bigger. But this part is the problem, because there are 3,000,000 entry in tab2 and tab3 and 100,000 entries in tab1.
The orcale version ist something like 8.0
Bye from Wunstorf, Germany
Christian Received on Sun May 22 2005 - 06:31:49 CDT