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

Christian Wapenhans wrote:
That has all documentation on line, going back to 7.3.4.
May require a (free) subscription.

No pun intended, but you seem hardly the person to
optimize Oracle statements, if you don't even know the
basics like "how to display records from one table,
that do not exist in the other?"

What is the mssql statement you used for, like V2.2?

--
Regards,
Frank van Bortel

Christian Wapenhans wrote:
I don't intend to be too negative here but every indication from your
post is that you are lacking the skills to be successful. You MUST
know the exact version number.

Go to http://www.psoug.org
click on Morgan's Library
click on Joins
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

In <1116773369.869335@yasure>, on 05/22/05
at 07:53 AM, DA Morgan <damorgan (AT) psoug (DOT) org> said:



That's not the problem. I'll know that next week.


Bye
Christian