不能在一条语句中更新两个表。但是，您可以使用事务来确保这两个语句作为单个单元进行更新。如果一个失败，两个都将回滚。

BEGIN TRANSACTION;

UPDATE profil
SET profil.passwort = ?
FROM profil, kunde
WHERE profil.id = kunde.id //Here you use the secondary key and primary keys to link the tables
and profil.email = ?;

UPDATE kunde
SET kunde.username = ?, kunde.bio = ?
FROM profil, kunde
WHERE profil.id = kunde.id //Here you use the secondary key and primary keys to link the tables
and profil.email = ?;

COMMIT;