I get a generic error message, and have no idea what the problem is with the query. What do I do to fix this?

Query explanation: there are two tables, Invoice, and temp. I need to take zip codes from temp table and push them to the Invoice table, based on the invoice number.

```
START TRANSACTION

UPDATE 
Invoice
SET 
Invoice.zip_code = (SELECT zip_code FROM temp WHERE temp.invoice_number = Invoice.invoice_number)
WHERE 
Invoice.invoice_date >= '2017-08-01'

ROLLBACK

```

this is the error:

> 
> Error Code: 1064 You have an error in your SQL syntax; check the
>  manual that corresponds to your MySQL server version for the right
>  syntax to use near 'UPDATE Invoice SET Invoice.zip\_code = (SELECT
>  zip\_code FROM temp WHERE temp' at line 3
> 
> 
>