title: SQL Update with multiple INNER JOIN
body: <p>I have two tables, </p>
  
  <pre><code>SELECT [SHADOW_ID]
        ,[DATA]
        ,[TSN]
        ,[HEALTH_PLAN_CATEGORY_VALUE_ID]
  FROM [stbl834]
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT [HEALTH_PLAN_CATEGORY_VALUE_ID]
        ,[TSN]
  FROM [uvwCLIENT_HEALTH_PLAN]
  </code></pre>
  
  <p>Right now HEALTH_PLAN_CATEGORY_VALUE_ID are all set to NULL in stbl834, I need to fetch these values from uvwCLIENT_HEALTH_PLAN based on different TSN values from stbl834. Is there a way to do this using JOIN statements? I need to avoid any sort of loops. </p>