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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Urgent help

Re: Urgent help

From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: 28 Jul 2003 14:15:25 -0700
Message-ID: <6dae7e65.0307281315.3e7d11e5@posting.google.com>


"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:<wBcVa.14$HN6.66_at_news.oracle.com>...
> "Lennart Jonsson" <lennart_at_kommunicera.umea.se> wrote in message
> news:6dae7e65.0307280207.62e12f8a_at_posting.google.com...

[...]

>
> I have a trouble understanding ANSI "inner join" syntax. In the example
> above, shouldn't it be:

that makes two of us then :-) I normally use:

 select * from A,B,C,D
 where a.x=b.x and b.y=c.y and b.z=d.z

In this case I was refering to a solution provided by jag for the same question asked in comp.databases.

[...]

> select * from A,B,C,D
> where a.x=b.x and b.y=c.y and b.z=d.z
>
> For one thing, how would you place brackets in this example?
>

I wouldnt.  

[...]

>
> Not to mention that Lennard put single table predicates in the "on" clause.

Besides the above, my name's spelled Lennart ;-)

[...] Received on Mon Jul 28 2003 - 16:15:25 CDT

Original text of this message

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