data view for Multi_org visibility for work.com blog post #2

heroku_data_view_amer_emea.sql

CREATE OR REPLACE VIEW global_assessment as
SELECT employeecrisisassessment.sfid AS id, 
employeecrisisassessment.assessment,
employeecrisisassessment.assessmentdate, 
employee.lastname, employee.firstname, 
'AMER' AS geo 
FROM amer.employeecrisisassessment, amer.employee   
WHERE employeecrisisassessment.employeeid = employee.sfid
UNION 
SELECT employeecrisisassessment.sfid AS id,
employeecrisisassessment.assessment,
employeecrisisassessment.assessmentdate,
employee.lastname, employee.firstname,
'EMEA' AS geo
FROM emea.employeecrisisassessment, emea.employee
WHERE employeecrisisassessment.employeeid = employee.sfid;