view_contact_info
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;
Version 2.5
Still in use
= 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;