Database/docs/tutorial_example_08.php

<?php

$db = ezcDbInstance::get();

$q = $db->createSelectQuery();

// $q->rightJoin( 'table1', 'table2', 'table1.id', 'table2.id' ) will produce
// string "table1 RIGHT JOIN table2 ON table1.id = table2.id"
// that should be added to FROM clause of query.
// resulting query is "SELECT id FROM table1 RIGHT JOIN table2 ON table1.id = table2.id".
$q->select( 'id' )->from( $q->rightJoin( 'table1', 'table2', 'table1.id', 'table2.id' ) );
$stmt = $q->prepare();
$stmt->execute();

?>