How to join three or more tables?

[eluser]doors[/eluser]
I want to create an array with data from three tables.

How would I go about doing that using the active record class?

It works with two tables easily but when I add anymore tables I get some errors.

Can someone place a simple example?