title: How to join two tables and return one row in PL/SQL?
body: <p>I have 2 tables which names are FIRST and USERS. In FIRST table i have USERID1,USERID2 and USERID3 columns. And USERS table i save USERID's names and surnames values. If i join tables;</p>
  
  <pre><code>SELECT f.userid1, f.userid2, f.userid3, u.name, u.surname
  FROM users u, first f
  WHERE f.userid1=u.userid AND f.userid2=u.userid AND f.userid3=u.userid
  </code></pre>
  
  <p>i want to return this result in 1 row like;</p>
  
  <pre><code>121314 name surname 131415 name surname 141516 name surname
  </code></pre>
  
  <p>FIRST table result example;</p>
  
  <pre><code>no   no2             userid1  userid2  userid3  ...
  7    100000545       121314   131415  141516   ....
  </code></pre>
  
  <p>USER TABLE </p>
  
  <pre><code>id        name      surname
  121314    black      smoke
  131415    jack       shephard
  141516    john       locke
  </code></pre>
  
  <p>i want to result like user table but i have to join because coming result must according to records from FIRST table</p>