Search Postgresql Archives

Re: Join help, please

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Join help, please
From: Michael Lewis <mlewis@xxxxxxxxxxx>
Date: Wed, 18 Mar 2020 13:36:24 -0600
Cc: PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAHOFxGrt+JWuP8BHuCGzxp2Xc2TOMerkSvzOAouv+2aHJ8_71w@mail.gmail.com>
References: <20200318185053.GA10351@panix.com> <CAHOFxGrt+JWuP8BHuCGzxp2Xc2TOMerkSvzOAouv+2aHJ8_71w@mail.gmail.com>

On Wed, Mar 18, 2020, 12:55 PM Michael Lewis <mlewis@xxxxxxxxxxx> wrote:

work_type.work_type_key = work_type.work_type_key

You've done a cross join.

You meant to do permitted_work.work_type_key = work_type.work_type_key I expect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Join help, please
  - From: stan
- Re: Join help, please
  - From: Michael Lewis

Prev by Date: Re: Join help, please
Next by Date: Re: SET LOCAL <var> doesn't become undefined after transaction is commited
Previous by thread: Re: Join help, please
Next by thread: Re: Join help, please
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux