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 по дате отправления: