Database/docs/tutorial_example_07b.php

<?php

$db = ezcDbInstance::get();

$q = $db->createSelectQuery();

// Right join of three tables. Will produce SQL:
// "SELECT id FROM table1 RIGHT JOIN table2 ON table1.id = table2.id RIGHT JOIN table3 ON table2.id = table3.id".
$q->select( 'id' )
        ->from( 'table1' )
            ->rightJoin( 'table2', 'table1.id', 'table2.id' )
            ->rightJoin( 'table3', 'table2.id', 'table3.id' );

$stmt = $q->prepare();
$stmt->execute();


?>