WHERE IN for JOIN subquery?

I want to do a JOIN against a subquery that is doing an aggregation. The query itself is relatively straightforward, but has poor performance. Here it is: SELECT a.*, b.* FROM base AS a LEFT OUTER JOIN (SELECT other, COUNT(value), COUNT(DISTINCT value) FROM other GROUP BY other) AS

Re: WHERE IN for JOIN subquery?

On Mon, Dec 18, 2017 at 5:00 PM, Dave Johansen 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

Re: WHERE IN for JOIN subquery?

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 > wrote: > >> >> other = a.other >> But I get this error: >> ERROR: invalid reference to FROM-clause entry for table "a" >> >> LINE 1: ...ue), COUNT(DISTINCT v