On Thu, Jul 21, 2016 at 3:29 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> On Thu, Jul 21, 2016 at 2:24 PM, Claudio Freire <klaussfreire@gmail.com>
> wrote:
>>
>> That cross join doesn't look right. It has no join condition.
>
>
> That is that the definition of a "CROSS JOIN"...
>
> David J.
Well, maybe it shouldn't be.
A cross join I mean.
I see the query and a cross join there doesn't make much sense.
There's no filtering of the output rows on the where clause either
AFAICT, and it's producing a lot of intermediate rows that don't seem
to be necessary. That was my point.