Francois, I would also suggest like Alessandro to use the built in functionality of PostGIS layers for a join. Either in the map file or as a DB view based on that join and then loading this view instead of the single tables.
The join function in pmapper was intended for shapefile layers where a join was either not available or the join with dbase fields was not working any more. I never tried if the join works also for PostGIS layers because I never thought that somebody would use such a combination. In case you might want to try it anyway, here's an example I once used for a shapefile/Postgres join: "pgsql://postgres:[EMAIL PROTECTED]/gisdb||[EMAIL PROTECTED]@[EMAIL PROTECTED]|copertura|landcover||CODE||1" Armin Fran?ois PINET wrote: > Hello, > > Excuse me for my bad english. > I use pmapper 1.9.4 with postgresql 8.0.4 and postgis 1.0.4. > I would like to know how can i make a query result with a data geometry > postgis and a field store in another postgresql table. > In fact i want to join data geometry with the field "code_insee" of my > "route" table with the field code_insee of my "commune" table. I want > the result "libcommune" in my query. > Can i have help please? > > Here is a part of my mapfile for this layer: > > LAYER # layer_route > NAME "route" > CONNECTIONTYPE postgis > CONNECTION "user=myuser password=mypass dbname=mydb host=localhost" > METADATA > "DESCRIPTION" "route" > "RESULT_FIELDS" "identifian,nom,code_insee,libcommune" > "RESULT_HEADERS" "Identifiant,nom,code_INSEE,commune" > "RESULT_JOIN" > "pgsql://postgres:[EMAIL PROTECTED]/sig||[EMAIL PROTECTED]@[EMAIL > PROTECTED]||code_insee||0" > "wms_srs" "EPSG:27582" > END > TYPE LINE > STATUS ON > DATA "the_geom from (select route.oid,* from route) as foo" > MAXSCALE 25000 > LABELITEM "nom" > CLASS > NAME "Route" > OUTLINECOLOR 50 230 32 > TEMPLATE "ttt_query.html" > LABEL > TYPE TRUETYPE > FONT arial > COLOR 255 0 0 > SIZE 7 > POSITION AUTO > MINDISTANCE 2 > ANGLE AUTO > POSITION AUTO > END > END > TOLERANCE 10 > END # layer_route > > Thanks a lot. > FP > > > ------------------------------------------------------------------------ > > _______________________________________________ > Pmapper-users mailing list > [EMAIL PROTECTED] > http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
