Re: New to new join syntax

"Tom Sacold" <tom.sacold_at_nospamntlworld.com> wrote in message news:%z6ye.27425$BD2.25564_at_newsfe1-gui.ntli.net...
> 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
>

RTFM!  select *
 from a inner join b on a.id1 = b.id1

            inner join c on b.id2 = c.id2 Received on Mon Jul 04 2005 - 04:00:56 CDT