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;

• 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;