Am Sonntag, 4. Mai 2008 schrieb Mag Gam:
> To my understanding, it is preferred to use the INNER JOIN keyword. I am
> able to INNER JOIN 2 tables, but I am not sure of the syntax for 3 or more
> tables. Can someone please show me an example for that ?
Just concatenate the joins, modern servers do not need hints by brackets and
such:
select * from a join b on a.id=b.aid join c on b.id=c.bid ;
In that respect, also take a look on "join using" and "natural join".