Subquery returned more than 1 value. This is not permitted when the subquery follows ... when the subquery is used as an expression
<p>I looked over the other answers, but none of them answered what I am doing wrong or I don't get it.</p>

<p>I am trying to update a table from another table, but they don't share a common reference. A third table does share a reference with both of theses tables, so how do I get them to reference each other to do the update. Here is my best attempt.</p>

<pre><code>Update jobs

Set Phone = (Select coalesce([Work Phone], [Home Phone], [Cell Phone]) 
            from Contacts c  
                INNER JOIN Easement_Contacts e on c.CPID = e.Contact_ID)

Where Exists (Select Contact_ID 
              from Easement_Contacts e 
                  INNER JOIN Jobs j on j.Easement = e.Easement_ID)
</code></pre>