v1_login_email

CREATE VIEW v1_login_email AS
SELECT contact, firstName
FROM contacts, persons, access
WHERE contacts.idPerson = persons.id
AND contacts.idContactType =2
AND access.idAccessType =1
AND persons.idUser = access.idUser