Join multiple row/column MySQL
<p>Trying to do things a bit different with a database, I got a table called "services", this table consist off pID, uID, serviceID.</p>

<p>Then I got a table called "user_profile", that of course got the same uID as used in the table services.</p>

<p>So a user can have multiple services, let's say</p>

<pre><code>pID     uID     serviceID
1       1       101
2       1       102
3       1       104
4       2       105
</code></pre>

<p>So how do I join this to my user_profile data? I'm a bit confused about that.</p>

<p>Let's say somebody visits the profile with uID 1.</p>

<p>Then I need all the services to in the same SQL call if that's possible somehow?</p>

<p>Hope I make abit of sense.</p>