Re: Urgent help
Date: 28 Jul 2003 14:15:25 -0700
Message-ID: <6dae7e65.0307281315.3e7d11e5_at_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 - 23:15:25 CEST