arcadeicons
Member
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?
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?