title: SQL Select query to return Foreign Key value and update original value
body: <p>I am somewhat new to MS SQL but I have been able to figure out how to get a Foreign key to return through a query, but I cannot figure out how to make it update the original value.</p>
  
  <p>Here is what I have so far: </p>
  
  <pre><code>SELECT prd_pk, prd_alt_desc
  FROM RM_AM.dbo.product
  WHERE EXISTS (SELECT prd_pk FROM dbo.Bn_Import WHERE prd_alt_desc = dbo.Bn_Import.Commodity);
  </code></pre>
  
  <p>I think I need a variable to do it, but I don't know enough of how to structure the query.</p>
  
  <pre><code>+------------+------------------+-------------------------+------------------+-----------------+-------------+
  | Ship Date  |   Original ETA   | Confirmed Delivery Date |   Current ETA    |    Commodity    | Load Status |
  +------------+------------------+-------------------------+------------------+-----------------+-------------+
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/1/2018  | 10/1/2018 18:49  | 10/4/2018               | 10/18/2018 10:28 | SANDFRAC4070MES | L           |
  | 10/11/2018 | 10/18/2018 11:48 | 10/20/2018              |                  | SANDFRAC4070MES | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/1/2018  | 10/1/2018 18:49  | 10/4/2018               | 10/18/2018 10:28 | SANDFRAC4070MES | L           |
  | 10/10/2018 | 10/17/2018 11:48 | 10/20/2018              |                  | SANDFRAC4070MES | L           |
  | 10/16/2018 | 10/19/2018 6:00  | 10/21/2018              | 10/19/2018 1:04  |                 | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/4/2018  | 10/11/2018 11:48 | 10/13/2018              |                  | SANDFRAC4070MES | L           |
  | 10/16/2018 | 10/19/2018 6:00  | 10/21/2018              | 10/19/2018 1:04  |                 | L           |
  | 9/17/2018  | 9/17/2018 18:49  | 9/21/2018               |                  | SANDFRAC4070MES | L           |
  | 10/1/2018  | 10/1/2018 18:49  | 10/4/2018               | 10/18/2018 10:28 | SANDFRAC4070MES | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/18/2018              |                  | SANDFRAC4070MES | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/15/2018 | 10/18/2018 6:00  | 10/21/2018              | 10/19/2018 4:24  |                 | L           |
  | 10/4/2018  | 10/11/2018 11:48 | 10/13/2018              |                  |                 | L           |
  | 10/1/2018  | 10/1/2018 18:49  | 10/4/2018               | 10/18/2018 10:28 | SANDFRAC4070MES | L           |
  | 10/16/2018 | 10/19/2018 6:00  | 10/21/2018              | 10/19/2018 1:04  |                 | L           |
  | 10/6/2018  | 10/13/2018 11:48 | 10/16/2018              |                  | SANDFRAC4070MES | L           |
  | 10/11/2018 | 10/18/2018 11:48 | 10/20/2018              | 10/19/2018 0:02  | SANDFRAC4070MES | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/4/2018  | 10/11/2018 11:48 | 10/14/2018              |                  | SANDFRAC4070MES | L           |
  | 10/1/2018  | 10/1/2018 18:49  | 10/4/2018               | 10/18/2018 10:28 | SANDFRAC4070MES | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/4/2018  | 10/11/2018 11:48 | 10/14/2018              |                  | SANDFRAC4070MES | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/18/2018              |                  | SANDFRAC4070MES | L           |
  | 9/14/2018  | 9/22/2018 19:50  | 9/26/2018               | 10/18/2018 14:01 | SANDFRAC4070MES | L           |
  | 10/4/2018  | 10/11/2018 11:48 | 10/13/2018              |                  | SANDFRAC4070MES | L           |
  | 10/7/2018  | 10/14/2018 11:48 | 10/18/2018              |                  |                 | L           |
  | 10/9/2018  | 10/16/2018 11:48 | 10/19/2018              |                  | SANDFRAC4070MES | L           |
  | 10/1/2018  | 10/1/2018 18:49  | 10/4/2018               | 10/18/2018 10:28 | SANDFRAC4070MES | L           |
  | 9/17/2018  | 9/17/2018 18:49  | 9/21/2018               |                  | SANDFRAC4070MES | L           |
  +------------+------------------+-------------------------+------------------+-----------------+-------------+
  </code></pre>
  
  <p>I need to change the commodity from SANDFRAC4070MES to 6710</p>
  
  <p>6710 is the Foreign Key for another table in our database.</p>