User Tools

Site Tools


podoc:view_contact_sql_view

Database View Description of "view_contact"

Name

view_contact

Description

Purpose

Schema

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;

History

Used first

Version 2.5

Used last

Still in use

Change history

= 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;
podoc/view_contact_sql_view.txt · Last modified: 2007/04/20 11:40 by Luud