Il giorno ven, 27/04/2012 alle 10.28 +0100, James Stott ha scritto:
> I am trying to run a query in QGIS. The query below works in QGIS 1.7.4
> but I cannot get it to open in 1.9 (Windows 7).
>
> SELECT "units"."gid", "units"."name", "pipe"."section",
> "units"."the_geom"
> FROM "data"."units", "data"." pipe"
> WHERE " pipe"."section" = 'W' and ST_DWithin("pipe"."the_geom",
> "units"."the_geom", 500);
>
> Does anyone know what I am doing wrong?
Hi James,
I see a blank space in name table (pipe) in clause FROM:
FROM "data"."units", "data"." pipe"
Could be the problem there?
Regards,
-SL
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
