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;
Related tables
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