title: SQL field as sum of other fields
body: <p>This is not query related, what I would like to know is if it's possible to have a field in a column being displayed as a sum of other fields. A bit like Excel does.</p>
  
  <p>As an example, I have two tables:</p>
  
  <p>Recipes</p>
  
  <pre><code>nrecepie integer
  name varchar(255)
  time integer
  </code></pre>
  
  <p>and the other</p>
  
  <p>Instructions</p>
  
  <pre><code>nintrucion integer
  nrecepie integer
  time integer
  </code></pre>
  
  <p>So, basically as a recipe has n instructions I would like that </p>
  
  <pre><code>recipes.time = sum(intructions.time)
  </code></pre>
  
  <p>Is this possible to be done in create table script?? if so, how?</p>