On Thu, 10 Nov 2005 09:45:58 -0600, Steven Monai <[EMAIL PROTECTED]> 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 >-- >
