inner joins and outer joins

can anybody guide me on how to create inner joins and left and right
outer joins in RoR as both the tables has "has and belongs to many
relationships" and there is ajoin table as well

Wasim Akram wrote:

can anybody guide me on how to create inner joins and left and right
outer joins in RoR as both the tables has "has and belongs to many
relationships" and there is ajoin table as well

all joins are implicitly "inner". If you want to use either a right or
left outer join then you just state them in your join clause..

Model.find(:all, :joins => "right outer join .... ") etc..

hth

ilan