title: how to retrieve one row of many selected rows
body: <p>I would like to select multi col across multi table in order to display them as only one row in MYSQL </p>
  
  <p>like this example: </p>
  
  <pre><code>     ___________
      |uId|xID|yID| 
      |_1_|_2_|_4_|
  </code></pre>
  
  <p>Into </p>
  
  <pre><code> ___
  |zId|
  | 1 |
  | 2 |
  | 4 |
  </code></pre>
  
  <p>here is the query but col t returns null data beside all of the selected cols </p>
  
  <pre><code>SELECT `flaghsip_leader`,`clustuer_coordinator_id`,`clustuer_cocoordinator_id`,
      `flagship_activity_coleader_id`,`flagship_activity_focalpoint_id`,
      `output_leader_id`,`output_coleader_id` AS `t` 
  FROM crpcoreix.view_all_involved_users;
  </code></pre>