1. Important notice about Cloudbleed - if your site uses the Cloudflare CDN, and you intend to follow the Joomla security team's advice to change your site "secret", you MUST READ THIS NOTICE.
  2. Fabrik 3.6 Released Remember to backup and test your backup before proceeding with this update. Please report any problems you might experience with this new version here on the forum. You are safe to upgrade to Joomla! 3.7 and PHP 7.x with this version of Fabrik. View the blog for more details on this release.

Two fields in list joined to _table_user.name????

Discussion in 'Community' started by arcadeicons, Mar 17, 2017.

  1. arcadeicons

    arcadeicons Member

    Level: Standard
    I have a form which captures two user ID's in it's table...

    submit_score.gamerID
    submit_score.createdbyID

    In my list view of the form's table I need to join to #_users.id from both of the above fields so I can show #_users.name in my list display. I can do one with an innerJoin but how can I retrieve the same info for the second value?
     

Share This Page