Join between Postgis table and Postgresql table

[Carlo Calvino]

On Thu, 10 Nov 2005 09:45:58 -0600, Steven Monai
<stevem at SPATIALMAPPING.COM> wrote:

Steven,
it worked!! Thank you very much! :)
But now it remains the most important problem: What about 1-to-many
relationships? I have a shapefile with point features: let's suppose to
click on such a point, i want to see all the analysis (the rows in a
table) related to that point. With your suggestion, I can only view one
analysis. How can I handle this new situation?


>Carlo:
>
>If you look closely at the error message, it is saying that you need an
>alias for your subquery in the FROM clause. So, try this in your DATA
line:
>
>DATA "the_geom from (SELECT pippo.gid, pippo.the_geom, pippo.id_shape,
>opo.nome, opo.cognome   FROM pippo LEFT OUTER JOIN opo ON pippo.id_shape =
>opo.id_shape) as foo using SRID=4326 using unique gid  "
>
>Hope this helps,
>-SM
>--
>