title: Select Data from view vs Table of same name
body: <p>I have a database where a <strong>view and a table have same name</strong>, when I try to execute query </p>
  
  <pre><code>select * from XXXXXXXXX
  </code></pre>
  
  <p>from where is this data coming from, view or table? Is there any explicit declaration syntax to tell, to where from select the data?</p>
  
  <p><strong>PS:</strong> the DB owner is different so I can't change the structure of view/table or names either.</p>