title: Why is using '*' to build a view bad?
body: <p>Why is using '*' to build a view bad ?</p>
  
  <p>Suppose that you have a complex join and all fields may be used somewhere.</p>
  
  <p>Then you just have to chose fields needed.</p>
  
  <pre><code>SELECT field1, field2 FROM aview WHERE ...
  </code></pre>
  
  <p>The view "aview" could be <code>SELECT table1.*, table2.* ... FROM table1 INNER JOIN table2 ...</code></p>
  
  <p>We have a problem if 2 fields have the same name in table1 and table2.</p>
  
  <p>Is this only the reason why using '*' in a view is bad?</p>
  
  <p>With '*', you may use the view in a different context because the information is there.</p>
  
  <p>What am I missing ?</p>
  
  <p>Regards</p>