Le portail francophone de la géomatique

UPDATE habitats
SET etat_cons = 1
WHERE id_habitat IN (
        SELECT h.id_habitat
        FROM habitats h
        JOIN TYPO_PERSO t ON h."nom_français" = t."nom_français"
        WHERE etat_cons IS NULL
        AND t.statut not like 'habitat non d%')

Query execution error on CREATE TEMP VIEW _tview AS UPDATE habitats
SET etat_cons = 1
WHERE id_habitat IN (
        SELECT h.id_habitat
        FROM habitats h
        JOIN TYPO_PERSO t ON h."nom_français" = t."nom_français"
        WHERE etat_cons IS NULL
        AND t.statut not like 'habitat non d%'): 1 - near "UPDATE": syntax error

        SELECT h.id_habitat
        FROM habitats h
        JOIN TYPO_PERSO t ON h."nom_français" = t."nom_français"
        WHERE etat_cons IS NULL
        AND t.statut not like 'habitat non d%'