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. 

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):

```
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';

```

I may be over complicating this. Thanks.