title: query custom fields joomla
body: <p>I have added a custom fields on the user management, which works greats, the custom fields are save  on  <strong>fields</strong> <strong>fields_values</strong> tables, I don't find a way to join the info from user table <strong>users</strong> table and the fields tables in one query results.</p>
  <p>I need something like: <code>SELECT id,NAME,username,customfield FROM users WHERE Id=2</code></p>
  <p>How can I achieve that?</p>