title: MySQL subquery returns more than one row and inner joins
body: <p>I have the following query:</p>
  
  <pre><code>select user_name as rt, 
        (select source_user_name from tweets t where t.rt_user_name = u.user_name)
  from topUserData u
  </code></pre>
  
  <p>Now MySQL is giving me an error saying that the subquery returns more than one row. However, what I want here is this one to many relationship. For example if the user_name was james and the subquery returned (Linda, Bob, Suzanna, Sandy, Tom) then I would like the data to be displayed as:</p>
  
  <p>James   Linda</p>
  
  <p>James Bob</p>
  
  <p>James Suzanna</p>
  
  <p>James Sandy</p>
  
  <p>James Tom</p>
  
  <p>How do I get this functionality from what I have? I also see this is similar to an inner join but I want the answer in terms of a subquery. All help is appreciated.</p>