title: What should I use: inner join or 3 different queries?
body: <p>I have 3 tables</p>
  
  <ol>
  <li>member</li>
  <li>member videos</li>
  <li>member photos</li>
  </ol>
  
  <p>For member profile page, should I use one query with inner join like</p>
  
  <pre><code>SELECT member.*,member_photo.*,member_video.* 
  FROM (member 
      INNER JOIN member_photo ON member.member_id = member_photo.member_id
  ) 
  INNER JOIN member_video ON member.member_id = member_video.member_id
  </code></pre>
  
  <p>then push videos to a video array and photos to a photo array, but in here query finds same photos for every video so I have to check if this item added to array before.</p>
  
  <p>Or should I use 3 queries: first find member information, then one more query for member pictures, and one more query for member videos? Which way should I use? </p>