title: Query throwing error; "column ambiguously defined"
body: <p>I am running a query as </p>
  
  <pre><code>SELECT LOCATION_OID,UPPER(NAME) AS LOCATION_NAME FROM LOCATION LEFT OUTER JOIN LOCATION_CHILD_LOCATION parent on (parent.LOCATION_OID = LOCATION.LOCATION_OID) 
  </code></pre>
  
  <p>There are two table LOCATION and LOCATION_CHILD_LOCATION, Location has some 456 records and location_child_location has 4 records. The records in location_child_location are mapped with the location_oid from the parent i.e location table.
  Why is this query giving error?</p>