title: Hide column from a left join select
body: <p>Struggling a little on this, hopefully I can get some answers here. I am trying to remove a column that appears in my results from the SQL command. I don't want 'player_id' to be showing up twice (the second time it shows is coming from the below join statement). Tried manipulating the join statement but everytime I do, it fails to then fetch the data.</p>
  
  <pre><code>select * from org_members
  left join (select player_id, LISTAGG(ship_name, ', ') WITHIN GROUP 
  (order by ship_name) as Ships
  from member_ships 
  group by player_id) ships
  on org_members.player_id=ships.player_id 
  </code></pre>
  
  <p>Just as an FYI, running this through APEX on oracle 11gXE.</p>
  
  <p>EDIT: here is hte output
  <a href="https://i.stack.imgur.com/iKXE0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iKXE0.png" alt="select"></a></p>