I am trying to update an existing table named "residential_summary" from a temporary table called "a". I can query the temporary table a but when I try to use it in an update statement I get
Error Code: 1054 Unknown column 'a.meter' in 'where clause'
Is this something that you just cant do or am I somehow misinterpreting the syntax for Update? Why is my column unknown? Please elaborate because I am new at databases. Here is my code and a screenshot.
UPDATE residential_summary SET residential_summary.load_factor = a.load_factor WHERE a.meter = residential_summary.meter;