Hi

I have a question. It is very SQL-basic.

What are JOINs good for?

From what I read, I can do

select a.avalue, b.bvalue
from atable a, btable b
where a.id = b.id

as

select a.avalue, b.bvalue
from atable a join btable b
on a.id = b.id

Is there a difference? Until now, I only used the former approch, as it
seems more "natural" to me.

I also read about differences between diffent kinds of JOINS [left, inner,
outer, ..?]
Is there a good place to read about the differences?

Thanks,
Steffen