SQL-Duplicate column names
<p>I am using SQL developer and I am trying an outer join on two tables. The error it is showing is "Duplicate column names". I have used the table nameswhile comparison but still it is giving error. Code is as following:</p>

<pre><code>CREATE VIEW OECD_VIEW AS
SELECT * FROM DM_OECD_GDP FULL OUTER JOIN DM_OECD_DOCTORS 
ON DM_OECD_GDP.DATA_YEAR = DM_OECD_DOCTORS.DATA_YEAR;
</code></pre>

<p>I have heard that this error can be resolved by aliasing but I don't know how to alias while comparing. Can this be done?</p>

<p>Thanks</p>