title: Update table using query result
body: <p>I am attempting to add the result of my query into the column of an existing table.
  Thus far, the query below calculates the <code>CAR_PRICE</code> and displays the value. However, I want to add this value to the <code>CAR_PAYMENT_TBL</code> in the car_price column.</p>
  
  <p>The create table commands below show the relevant table and the relationships between them. Is it possible to update the <code>CAR_PRICE</code> value in the <code>CAR_PAYMENT_TBL</code>?    </p>
  
  <pre><code>SELECT C.TICKET_NO, 
              C.REG_ID,
              C.BOOKING_ID,
              (R.END_DATE-R.START_DATE) AS DAYS_STAYED,
              (R.END_DATE-R.START_DATE)*5 AS CAR_PRICE
              FROM CAR_TBL C
              LEFT JOIN
              ROOM_TBL R
              ON C.BOOKING_ID = R.BOOKING_ID;
  </code></pre>
  
  <p>TABLE SCHEMA:</p>
  
  <pre><code>CREATE TABLE CAR_PAYMENT_TBL
  (
      TICKET_NO INT NOT NULL PRIMARY KEY,
      CAR_PRICE NUMERIC(5,2) 
  );
  
  CREATE TABLE CAR_TBL
  (
      REG_ID VARCHAR2(7) NOT NULL PRIMARY KEY,
      TICKET_NO INT NOT NULL references CAR_PAYMENT_TBL(TICKET_NO),
      BOOKING_ID INT NOT NULL references BOOKING_TBL(BOOKING_ID)
  );
  
  CREATE TABLE ROOM_TBL
  (  
      STAY_NO INT NOT NULL PRIMARY KEY,
      ROOM_NO VARCHAR2(4) NOT NULL references ROOM_DETAILS_TBL(ROOM_NO),
      START_DATE DATE NOT NULL,
      END_DATE DATE NOT NULL,
      BOOKING_ID INT NOT NULL references BOOKING_TBL(BOOKING_ID)
  );
  </code></pre>