[@netweb Keymaster 13 years, 8 months ago]

Try this…

`
$this->field_map[] = array(
‘from_tablename’ => ‘UserRole’,
‘from_fieldname’ => ‘UserID’,
‘from_expression’ => ‘WHERE User.Deleted = 0′,
‘join_tablename’ => ‘User’,
‘join_type’ => ‘INNER’,
‘join_expression’ => ‘USING (UserID) WHERE UserRole.RoleID != 3′,
‘to_type’ => ‘user’,
‘to_fieldname’ => ‘_bbp_user_id’
);
`

Unless the ‘from_tablename’ is different from the other ‘from_tablename’ fields in each of the query sections it will not initiate the SQL ‘join’…

Its just one of those things going on in the whole ‘lets build some awseome SQL queries’