Data Between Two Tables <p>Excuse any novice jibberish I may use to explain my conundrum but hopefully someone here will be able to look past that and provide me with an answer to get me unstuck.</p> <p><strong>SESSIONS</strong></p> <pre><code>+--------+---------+----------+ | id | appID | userID | +--------+---------+----------+ | 1 | 1 | 96 | +--------+---------+----------+ | 2 | 2 | 97 | +--------+---------+----------+ | 3 | 1 | 98 | +--------+---------+----------+ </code></pre> <p><strong>USERS</strong></p> <pre><code>+--------+---------+ | id | name | +--------+---------+ | 96 | Bob | +--------+---------+ | 97 | Tom | +--------+---------+ | 98 | Beth | +--------+---------+ </code></pre> <p>For each session in the Sessions table that has an appID of <code>1</code>, I want to get the users <code>name</code> from the Users table. The Sessions <code>userID</code> column is linked with the Users tables <code>id</code> column. </p> <p>So my desired result would be:</p> <pre><code>["Bob", "Beth"] </code></pre> <p>Any suggestions/help?</p>