Caro João o raciocinio é bom mas está a devolver-me o seguinte erro:

*ERROR:  more than one row returned by a subquery used as an expression*



On 19-08-2011 14:19, João Carvalho wrote:
SELECT FID
  FROM rua
  WHERE (
      SELECT count(*)
      FROM passeio
      WHERE rua.FID=passeio.id_rua
      GROUP BY passeio.id <http://passeio.id>
      )>2

_______________________________________________
Portugal mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/portugal

Responder a