view_client

CREATE VIEW view_client AS
  SELECT client.identifier, client.users, client.client, users.last_name,
         users.first_name, date_of_creation, client_status.value, client.STATUS, users.type,
         client.TRUSTED
    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_client AS
  SELECT client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.STATUS, users.type
    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.19 =

DROP VIEW view_client;
CREATE VIEW view_client AS
  SELECT client.identifier, client.users, client.client, users.last_name,
         users.first_name, date_of_creation, client_status.value, client.STATUS, users.type,
         client.TRUSTED
    FROM client, users, client_status
   WHERE client.client = users.identifier
     AND client.STATUS = client_status.identifier
   ORDER BY users.last_name, users.first_name;