title: How to combine multiple queries into same table but different columns?
body: <p>So I have two tables that i'm working with.</p>
  
  <p>Users which consists of:
  <code>ID</code>, <code>NAME</code>, <code>CITY</code></p>
  
  <p>Follow which consists of: 
  <code>User(id)</code>, <code>Follow(id)</code></p>
  
  <p>I am trying to write a query that returns to me a table of the name of the user, the name of the follower's name and the followers city. I have this query written which returns the correct information, but prints it out 8 times for each row and I have no idea why.</p>
  
  <p>Here is a link to my code
  <a href="https://www.db-fiddle.com/f/aDPgZFknC1ybteWM6hwoFJ/3" rel="nofollow noreferrer">https://www.db-fiddle.com/f/aDPgZFknC1ybteWM6hwoFJ/3</a></p>
  
  <pre><code>FROM
  
  (SELECT user.name
   from follow, user
   where follow.user = user.id) as NAME,
  
   (Select user.name
    from follow, user
    where follow.follow = user.id) as FOLLOWER,
  
      (select city
      from user
      right join follow
      on user.id = follow.follow) AS CITY;
  </code></pre>