[Mapserver-users] RE: querying from 3 tables

[ryanne cruz]

hi list. 
 
i have a table that has a column (named "households") with the number of 
households in a certain area. this table (which i'll call table1) also has an 
"area_id" column. every "households" entry has a corresponding "area_id" entry 
but it is not unique. meaning a certain "area_id" can have more than one 
"households" entry.  
 
table2 also has an "area_id" entry which has a corresponding 
"municipality_id". in table2 "area_id" is unique but not "municipality_id". 
meaning a certain "municipality_id" may have more than one "area_id" partnered 
to it. 
 
in table3, the "municipality_id" is the primary key which means every entry of 
"municipality_id" is unique in table3. every "municipality_id" in table3 has a 
corresponding entry in the geom column. 
 
i have a map of a certain province. i want to show the number of households in 
each particular area of the province but i don't have the shapefiles yet of 
those areas. but i do have the shapefiles of the municipalities in that 
province. i want to add a layer on top of the province that will show the 
distribution of the number of households in the province using the geom of the 
municipalities. how do i do this?  
 
thanks! 
ryanne