title: FULL OUTER JOIN with two subselects gives "ORA-00918: column ambiguously defined"
body: <p>both Subselects runs fine standalone.</p>
  
  <p>But I wish to join them togehter, which always gives "ORA-00918: column ambiguously defined". I don't see why?</p>
  
  <p>Both subelects uses other names.</p>
  
  <pre><code>SELECT *
    FROM    (SELECT aods.user_id,
                    aods.firstname,
                    aods.lastname,
                    Aods.DEPARTMENT,
                    cods.jc_name
               FROM    personas aods
                    LEFT JOIN
                       user_jc cods
                    ON aods.user_id = cods.user_id
              WHERE cods.jc_name LIKE '%ADM%') ods
         FULL OUTER JOIN
            (SELECT abl.user_id,
                    abl.firstname,
                    abl.lastname,
                    Abl.DEPARTMENT,
                    bbl.ug_name
               FROM    personas abl
                    LEFT JOIN
                       ru_ug bbl
                    ON abl.user_id = bbl.user_id
              WHERE Bbl.UG_NAME LIKE '%ADM%'
                    AND bbl.rss_name = 'TIR') bl
         ON ods.user_id = bl.user_id
  </code></pre>