title: Subquery not allowed
body: <p>I'm trying to "auto-insert" my <code>MONEY</code> field on this table as the quantity of a product times the price of the product. I have the quantity value but the price will come from the foreign key <code>PRODUCT_ID</code> but I get error message: </p>
  
  <blockquote>
    <p>Subqueries are not allowed in this context. Only scalar expressions
    are allowed.</p>
  </blockquote>
  
  <p>This is the table. How can I do this "auto-insert"? If it is not possible this way please tell me another way I can do that. Thanks in advance.</p>
  
  <pre><code>CREATE TABLE ORDER_DETAILS
  (
  NUM_ORDER INT PRIMARY KEY,
  PRODUCT_ID VARCHAR(4) NOT NULL,
  QUANTIITY INT NOT NULL,
  MONEY AS (QUANTITY * (SELECT PRICE FROM PRODUCTS WHERE PRODUCTS.PRODUCT_ID = PRODUCT_ID)),
  ORDER_DATE DATETIME NOT NULL DEFAULT GETDATE()
  )
  </code></pre>