Complex SQL Query with Active Record

[eluser]Aljebrini[/eluser]
jedd, great job ..

isn't putting this " post.category_id = category.id " in where clause, gives the same results as join does ?

and please if you can give us samples for JOIN so we can understand how it works that's will be great,
thank you