Join help, please
| От | stan |
|---|---|
| Тема | Join help, please |
| Дата | |
| Msg-id | 20200318185053.GA10351@panix.com обсуждение исходный текст |
| Ответы |
Re: Join help, please
Re: Join help, please |
| Список | pgsql-general |
I am confused. given this view:
AS
SELECT
employee.id ,
work_type.type ,
permit ,
work_type.overhead ,
work_type.descrip
from
permitted_work
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
В списке pgsql-general по дате отправления: