MySQL how to query five tables in one SELECT : <p>I have 5 tables as follows:</p>

<ul>
<li><strong>tbl_individ</strong> - consists of user data (<em>uID, Firstname, Lastname, Mobile, eMail</em>)</li>
<li><strong>tbl_role</strong> - consists of roles (<em>rID, Rolename, RoleDescription</em>)</li>
<li><strong>tbl_group</strong> - consists of groups (<em>gID, Groupname, GroupDescription</em>)</li>
<li><strong>tbl_inro</strong> - consists of which roles a user has (<em>uID, rID</em>)</li>
<li><strong>tbl_ingr</strong> - consists of which groups a user belongs to (<em>uID, gID</em>)</li>
</ul>

<p>I'd like to achieve the output where I list all the users in the <strong>tbl_individ</strong> and list what each user what roles they has and as well what groups they belong to.</p>

<p>I created the <strong>tbl_inro</strong> to only map the user (uID) and the role (rID) and the same for the <strong>tbl_ingr</strong> to only map the user (uID) and the group (gID).</p>

<p>It all as output in one row?</p>
