TIMESHEET_HOURS_VIEW |
||
| Column Name | Data Type | Nulls |
|---|---|---|
| person_time_key | decimal (15,0) | |
| quantity | decimal (38,2) | YES |
Tables Used |
| PERSON_TIME_DATA |
| PERSON_TIME |
SQL*Server Create Statement: |
/* *************************************************************************** */
/* */
/* Step 9 - Create the views */
/* */
/* *************************************************************************** */
CREATE VIEW timesheet_hours_view (person_time_key,quantity) AS
SELECT t.person_time_key,
sum(s.quantity)
FROM person_time t,
person_time_data s
WHERE s.person_time_key =* t.person_time_key
GROUP BY t.person_time_key
|