title: View resolution definition
body: <p>I am currently studying up for an exam and one of the past paper questions is on view resolution. After having a Google around I have only made myself more confused on what exactly it is. </p>
  
  <p>Sadly our lecture slides don't cover the subject in great detail. From what I understand it where the view definition is combined with a query. So for example you could select a view from within the view you are defining and it will run as if it was a normal query.</p>
  
  <p>So where redandlondon is defined as:</p>
  
  <pre><code>CREATE VIEW redandlondon (pno, pname, mass)
  AS SELECT pno, pname, weight * 2.2
  FROM p
  WHERE city = 'London'; 
  </code></pre>
  
  <p>Both the following will result in the same output</p>
  
  <pre><code>SELECT pname, mass
  FROM redandlondon
  ORDER BY pname;
  
  SELECT pname, weight * 2.2
  FROM p
  WHERE city = ‘London’
  ORDER BY pname; 
  </code></pre>
  
  <p>Any help where I am wrong would be greatly appreciated and perhaps a simpler definition.</p>
  
  <p>Thanks</p>