SQLite update query - subquery with aliases doesn't work
UPDATE commands do not have a FROM clause.
Use a correlated subquery:
UPDATE LocationSET Address = (SELECT CallNumber FROM Location L2 WHERE L2.RefID = Location.RefID AND L2.Address = 'Lit')WHERE Address = 'temp'