v1_passwords

CREATE VIEW v1_passwords AS
SELECT * FROM passwords WHERE id IN (
    SELECT MAX(id) FROM passwords GROUP BY idUser)

SELECT idUser, username, psw FROM users, v1_passwords WHERE users.id = v1_passwords.idUser

SELECT idUser, username, psw FROM users JOIN v1_passwords ON users.id = v1_passwords.idUser