title: sql select query - alias name for column in joins is not working
body: <p>I have a query which is working fine..</p>
  
  <pre><code>SELECT 
      WSDEFN.WORKSPACE_DISPLAY_NM,
      LAYDEFN.LAYOUT_DISPLAY_NM,
      WSLMAP.POSITION,
      LAYDEFN.LAYOUT,
      LAYDEFN.PROPORTION,
      LAYDEFN.LAYOUT_ID,
      WSDEFN.WORKSPACE_ID,
      LAYDEFN.BUNDLE_KEY 
  FROM 
      WORKSPACE_DEFINITION WSDEFN,
      WORKSPACE_LAYOUT_MAP WSLMAP,
      LAYOUT_DEFINITION LAYDEFN
  WHERE 
      WORKSPACE_ID = WSLMAP.WORKSPACE_ID
      AND WSLMAP.LAYOUT_ID = LAYDEFN.LAYOUT_ID 
      AND WSDEFN.OD_USER_NO = '-1' 
      AND WSDEFN.OD_GCIF = '-1'
  ORDER BY 
      wsdefn.workspace_id, WSLMAP.POSITION
  </code></pre>
  
  <p>But I want to fetch the <code>WSDEFN.WORKSPACE_ID</code> as <code>WORKSPACE_ID</code>.</p>
  
  <p>I tried this</p>
  
  <pre><code>WSDEFN.WORKSPACE_ID AS WORKSPACE_ID,
  </code></pre>
  
  <p>but I get an error </p>
  
  <blockquote>
    <p>'column ambiguously defined'</p>
  </blockquote>
  
  <p>Could you give me a solution?</p>