User Tools

Site Tools


podoc:view_contact_info_sql_view

Database View Description of "view_contact_info"

Name

view_contact_info

Description

Purpose

Schema

CREATE VIEW view_contact_info AS
  SELECT identifier, address1, address2, city, zipcode,
         (SELECT VALUE FROM state WHERE state.identifier=contact_info.state) AS state,
         (SELECT VALUE FROM country WHERE country.identifier=contact_info.country) AS country,
         phone, email, url
    FROM contact_info;

History

Used first

Version 2.5

Used last

Still in use

Change history

= Version 2.5 =

CREATE VIEW view_contact_info AS
  SELECT identifier, address1, address2, city, zipcode,
         (SELECT VALUE FROM state WHERE state.identifier=contact_info.state) AS state,
         (SELECT VALUE FROM country WHERE country.identifier=contact_info.country) AS country,
         phone, email, url
    FROM contact_info;
podoc/view_contact_info_sql_view.txt · Last modified: 2007/04/20 15:41 by Luud