SQL Query to Update One Table if Value Matches in Another
<p>I am having trouble writing an SQL query which I am trying to do using an Update and Join. I have already checked online here and there are numerous similar examples but I haven't been able to get them to work as yet. </p>

<p>I am trying to do a join between Table A and Table B (on a unique id linking them) and then update a value in Table A, if two of the values found in Table B match what what I am expecting (which I am inputting manually in the statement):</p>

<pre><code>UPDATE TableA 
INNER JOIN TableB ON TableA.UniqueId = TableB.UniqueId 
SET TableA.email = 'emailaddress' 
WHERE upper(TableA.user) = upper('user') AND TableB.Account = 'accountnumber' 
      AND TableB.userType = 'usertype';
</code></pre>

<p>I may be over complicating this. Thanks.</p>