postgis table joins in layer DATA and FILTER

[David Niergarth]

Hi Steve,

Stephen Woodbridge wrote:
> Try this:
> 
> DATA "the_geom from (select the_geom, name, checked, gid from sm100k a, 
> files b where a.uid=b.uid ) as foo using SRID=4326 using unique gid"
> 
> You have to put your joins into a sub-select.

Ah! Using an anonymous table, the join is now working. I'm still figuring out 
the "using unique gid" bit at the end. Is gid like an oid for geometry tables? 
My table has no gid column. Is that something I can add?

Gold coins for you!

--David