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;

• client
• client_status
• users

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;