title: MySQL Database value of cell in one table calculated with amount of rows in another table
body: <p>I have two database tables and in one of them i want one of the cells to equal the amount of rows in the other table multiplied by a specific number e.g. 2000.</p>
  
  <p>So for example if there are 10 rows in table 1 i want one of cells in table 2 to be the sum of (2000 x 10).</p>
  
  <p>How can i achieve this?</p>
  
  <hr>
  
  <p>What i am trying to achieve:</p>
  
  <p>What i am trying to do is create a kind of banking database for a virtual company. One of the tables in the database would collect values from a form on a website and then these values would be chucked into this table and would appear as the data for each 'employee' e.g. profits, costs etc. </p>
  
  <p>The second table would total up the 'employees' to create the data for the company as a whole.</p>
  
  <p>E.g.</p>
  
  <p>In the 'employees' table there might be a column called 'fuel cost'.
  In the company table there would be a column called 'total fuel cost' which would be equal to the sum of all the employees fuel costs and then this would be displayed on a website.</p>