Re: Need help with INNER Join

Mag Gam wrote:
> When I needed to join tables I always used the equal syntax (ie. SELECT
> id from foo,fee where id.foo=id.fee)
>
> 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 ?


Your example will not work; you should have written:

SELECT foo.id from foo,fee where foo.id=fee.id

With inner join, this would be

SELECT foo.id FROM foo
INNER JOIN fee on foo.id=fee.id

Joining a third table would look like

SELECT foo.id FROM foo
INNER JOIN fee ON foo.id=fee.id
INNER JOIN bar ON bar.id=foo.id