title: is lookup function available in SQL server
body: <p>I am trying to do the following task. I have 2 tables with following data?  </p>
  
  <p>Table1 : </p>
  
  <pre><code>objectid    name          LOCATION   Project Manager
  
  4584     Client             NULL     Indicator
  
  4591     Ericsson           NULL     Indicator
  
  4604     NEW201             Text     NULL
  </code></pre>
  
  <p>Table2: </p>
  
  <pre><code>projectobjectid     name      value
  
  4584             Indicator    Red
  
  4591             Indicator    Green
  
  4604             Text         Sf001-bb1-5
  
  4604             Text         Sf001-bb1-4
  
  4604             Text         Sf001-bb1-3
  
  4604             Text         Sf001-bb1-2
  </code></pre>
  
  <p>result as follows:</p>
  
  <pre><code>objectid    name                     LOCATION        Project Manager
  
  4584        Client                     NULL              Red
  
  4591        Ericsson                    NULL             Green
  
  4604         NEW201                  Sf001-bb1-5          NULL
  
  4604         NEW201                  Sf001-bb1-4          NULL
  
  4604         NEW201                  Sf001-bb1-3          NULL
  
  4604         NEW201                  Sf001-bb1-2          NULL
  </code></pre>
  
  <p>Update Table 1 from Table 2. </p>