Re: A little complicated SQL

From: Alex Kizub <akizub_at_yahoo.com>
Date: 19 Jul 2002 10:59:59 -0700
Message-ID: <9d4ba33b.0207190959.757775d@posting.google.com>

Thank you guys for your discussion.
I can give you reason number zero.

#0. Production support team affraid of any kind of intrussion from "unqualified"
developers. Or if you have product from third part which does not allow to have access to their database with triggers, PL/SQL and other stuff which can slow
or corrupt their system.

If you guys live only in stidents world and prefer to work only with students then why yuo don't want to help them with thier home work?

And, of course, it is very helpful message in news that you, personally, will not help anybody to help with homework!

In my opinion if you don't want then don't answer! I can see only one another reason for that. You want to show how smart you are and how stupid students are.
And, again, in my opinion, there is only one way to show this - answer the question.

And here is answer from another source. It was little more complicated then I expected, but you can use it in your homework :)

select v1.a, v1.b, v2.c
from

(select t1.a, t2.b

      from t1, t2) v1,


     (select x1.a, x2.b, x1.c

      from x1, x2
      where x1.d = x2.d (+)) v2

where v1.a = v2.a (+)
  and v1.b = v2.b (+)

Alex Kizub.

P.S.
Don't answer, I don't like flame.
Just use it as good example of SQL power! Received on Fri Jul 19 2002 - 12:59:59 CDT