I talk with Armin for suggestion on this topic. The best choice seems to be using of VIEW in postgresql
You CREATE VIEW with a JOIN (I didn't get if both you table are with geometry) and after use the view instead of table, with all rules you do for table. I hope I got well your question luca On 9/9/06, Pemula <awanforever at yahoo.com> wrote: > sorry for my english > > i have question: > i will join 2 tables from PostgreSQL/PostGIS data. > i use full geodatabase, it means that my data only > from posgresql/postgis and not from shapefile. > > my first table is "room" with field: > "id_room,name_room" > my second table is "user" with field: > "id_user,id_room,name_user" > > "id_room" is a foreign key for that tables > > i want to show attribute "name_user" from "room" layer > > what must i do?? > > regrads > > -fery- > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > _______________________________________________ > Pmapper-users mailing list > Pmapper-users at faunalia.it > http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users > -- luca marletta www.beopen.it
