title: How does one use join in mysql and avoid duplicate entries in response
body: <p>i've tried both of these and continue to get a duplicate for each credit data entry:</p>
  
  <pre><code>SELECT DISTINCT * FROM
  FROM  `mediaDATA` 
  LEFT JOIN media_creditsDATA ON mediaDATA.id = media_creditsDATA.media_id
  
  SELECT * 
  FROM  `mediaDATA` 
  LEFT JOIN media_creditsDATA ON mediaDATA.id = media_creditsDATA.media_id
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/LmpkU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LmpkU.png" alt="enter image description here"></a></p>