Home > mailing lists

Re: Join help, please - Mailing list pgsql-general

From	Michael Lewis
Subject	Re: Join help, please
Date	March 18, 2020 22:36:24
Msg-id	CAHOFxGrTJuGcYkxdakYixLDzcrJF3j_fzEptFWm85rB5emTVwA@mail.gmail.com Whole thread Raw
In response to	Re: Join help, please (Michael Lewis <mlewis@entrata.com>)
List	pgsql-general

On Wed, Mar 18, 2020, 12:55 PM Michael Lewis <mlewis@entrata.com> 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

From: Guyren Howe
Date: 18 March 2020, 21:57:08
Subject: Re: Join help, please

From: Kostya
Date: 18 March 2020, 23:13:52
Subject: Re: SET LOCAL doesn't become undefined after transaction is commited