New to new join syntax

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 Received on Mon Jul 04 2005 - 03:38:19 CDT