I am confused. given this view:
inner join employee on
employee.employee_key = permitted_work.employee_key
inner join work_type on
work_type.work_type_key = work_type.work_type_key
Why do I have 38475 rows, when the base table only has 855?
My thinking was that the inner joins would constrain this view to the rows
that exist in the base (permitted_work) table.
Clearly I am misunderstanding something basic here.
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
work_type.work_type_key = work_type.work_type_keyYou've done a cross join.