Re: New to new join syntax

Tom Sacold wrote:
> Hi
>
> I've just had to start using all of this 'inner join' stuff and I have hit
> what must be a very simple problem - How do you do multiple joins in the new
> syntax?
>
> I spent 3 hours yesterday trying to work out how do:
>
> select *
> from a, b, c
> where a.id1 = b.id1,
> and b.id2 = c.id2

select *
from a, b, c
where a.id1 = b.id1 -- new comma
and b.id2 = c.id2

Demos of ISO and ANSI syntax at www.psoug.org click on Morgan's Library
click on SELECT

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)