zend-db-sql join example

zend-db-sql-join-example.php

<?php

// other setup code...

$select
    ->where([
        'id = ?' => $userId
    ])
    ->join(
        ['r' => 'tblroles'],
        'r.userid = tbluser.id',
        [
            'role'
        ],
        Select::JOIN_INNER
    );

print $select->getSqlString();