data view for multi-org visibility for work.com blog post #3

heroku_data_view_for_accounts_contacts.sql

CREATE OR REPLACE VIEW global_assessment as
SELECT contact.sfid as id, industry, account.name, phone, fax,
lastname, firstname, email, mobilephone,
'AMER' AS geo
FROM amer.account, amer.contact
WHERE amer.account.sfid = amer.contact.accountid 
UNION
SELECT contact.sfid as id, industry, account.name, phone, fax,
lastname, firstname, email, mobilephone,
'EMEA' AS geo
FROM emea.account, emea.contact
WHERE emea.account.sfid = emea.contact.accountid;