public function testRightJoin() { $args = new ArgumentArray(); $driver = new MySQLDriver(); $query = new SelectQuery(); $query->select(array('id', 'name', 'phone', 'address'))->from('users', 'u'); $query->rightJoin('posts')->as('p')->on('p.user_id = u.id'); $sql = $query->toSql($driver, $args); is('SELECT id, name, phone, address FROM users AS u RIGHT JOIN posts AS p ON (p.user_id = u.id)', $sql); return $query; }