Awesome catch, thanks. All working now.
Armin Burger wrote:
> Kyle
>
> I enabled the DEBUG for the layers and I discovered the problem with
> your data definition when applying the query directly on the table:
>
> You specified 'USING UNIQUE gid' but gid is not unique after the joining
> sinc
Kyle
I enabled the DEBUG for the layers and I discovered the problem with
your data definition when applying the query directly on the table:
You specified 'USING UNIQUE gid' but gid is not unique after the joining
since you multiply it with the joins. If you specify 'USING UNIQUE pid'
then ev