CREATE VIEW expense_approval_view AS
SELECT expense_report.
expense_report_key,
person.first_name,
person.middle_initial,
person.last_name,
person.suffix,
sum(expense_data.amount) report_total,
expense_report.status,
expense_report.controller_key,
expense_report.created
FROM expense_report, expense_data, person
WHERE expense_report.owner_key = person.person_key AND expense_report.status = 'SUBMITTED'
GROUP BY expense_report.expense_report_key,
person.first_name,
person.middle_initial,
person.last_name,
person.suffix,
expense_report.status,
expense_report.controller_key,
expense_report.created
|