view_contact
CREATE VIEW view_contact AS SELECT client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status FROM client, users, client_status WHERE client.client = users.identifier AND client.status = client_status.identifier ORDER BY users.last_name, users.first_name;
Version 2.5
Still in use
= Version 2.5 =
CREATE VIEW view_contact AS SELECT client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status FROM client, users, client_status WHERE client.client = users.identifier AND client.status = client_status.identifier ORDER BY users.last_name, users.first_name;