title: (SQL) How do I differentiate 2 columns from different tables with the same name when selecting?
body: <p>I'm using an Oracle 12c SQL server. The goal is to create a view containing each company and the drugs it produces.</p>
  
  <p>How can I differentiate two columns with the exact same name but located in different tables using SELECT?
  All relevant code below, including results with error.</p>
  
  <p>I understand why I might be getting a duplicate name error as they both have the same header "name", but thought I handled it by identifying the table beforehand (i.e. pc.name and dg.name). Help!</p>
  
  <p>SQL Tables Being Joined:</p>
  
  <p><a href="https://i.stack.imgur.com/C9JC9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C9JC9.png" alt="enter image description here"></a></p>
  
  <p>SQL Column Naming Error:</p>
  
  <p><a href="https://i.stack.imgur.com/57kmE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/57kmE.png" alt="enter image description here"></a></p>