[Qgis-user] filter on SELECT DISTINCT

[Matt Boyd]

Hi Group,
I've a set of polygons in a sqlite file. Some of the adjacent polygons have
the same name, others don't. I only want to display the name once.

I'm attempting to do this by copying the layer, then filtering on the label
column.

"label" in (SELECT DISTINCT label FROM gippsland_oilgas_fields_mga55)

but, it's not filtering, I can either get all polygons or none. It's
probably a simple thing in my sql I'm missing (it's been a while since I
did this).

Thanks
Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131129/f533ab18/attachment.html>