On Mon, Dec 18, 2017 at 5:10 PM, David G. Johnston < [email protected]> wrote:
> On Mon, Dec 18, 2017 at 5:00 PM, Dave Johansen <[email protected]> > 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. Thanks, Dave
