On Mon, Dec 18, 2017 at 5:10 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:

> On Mon, Dec 18, 2017 at 5:00 PM, Dave Johansen <davejohan...@gmail.com>
> wrote:
>> other = a.other
>> But I get this error:
>> ERROR:  invalid reference to FROM-clause entry for table "a"
>> LINE 1: ...ue), COUNT(DISTINCT value) FROM other WHERE other=a.other GR...
>> HINT:  There is an entry for table "a", but it cannot be referenced from
>> this part of the query.
> One possible solution to this error is to add the word "LATERAL" before
> LEFT JOIN so that the right side of the join can reference variables from
> the left side.

That appears to be what I was looking for.

Reply via email to