Error: table name specified more than Once

Question

I created a column included in the app table, it works to record the purchase date of the app and I will have to update the old records with the user creation date. I made a query to solve the problem, but postgresql accuses an error:

ERROR: table name "app" specified more than Once

This is my query:

UPDATE app
  SET app.inclusao = usuario.inclusao
  FROM app, usuario
  WHERE app.usuario = usuario.codigo

How do I fix this?

Answer 1

update app
    set inclusao = usuario.inclusao
    from usuario
    where app.usuario = usuario.codigo