Join query problem

[eluser]danmontgomery[/eluser]
[quote author="andriu" date="1267127986"]With the code above I just get either the client or the elevator.[/quote]

You're mistaken... With the code above you get the data from all 3 tables. With active record when you don't specify a select(), it defaults to "SELECT *". When you join tables and SELECT *, it selects all columns from all tables (The values will be NULL when join conditions aren't met). You might have some collisions in column names, but you are getting all of the data. Alternately, you can just specify which table's data you want.

Code:

$this->db->select("incedencias.*, elevators.some_data, clients.some_data");

You can then programmatically determine which fields are null.

To directly answer your question, you can join a table twice (as many times as you want actually, you can even join a table to itself), but I don't think that's what you want to do here.