Hi folks I have some troubles to create a SQL-query and my hope is that someone of you could help me with this.. It's somewhat difficult to explain what I want to do but I'll give it a try and see if you can understand the problem.. Ahh fuck this.. It's almost imposible to explain.. :) I don't understand what it mys self after I have written it.. Read and see if you understand.. :)
I have three tables: Table_1: A table with meta data for areas (names, geometries and so..). Every area has a unique id. Example: 101 | 'small area' | 'area name' | geom 102 | 'small area' | 'area name' | geom. 103 | 'small area' | 'area name' | geom. 104 | 'LARGE area' | 'area name' | geom Table 2. A table with values for some smaller areas. Contains a reference to an id in table1 and a value Example: 101 | 12.5 102 | 5.5 103 | 6.5 Table_3: A cross reference table with id:s for witch areas are connected to each other. Eg. What smaller areas that's is inside a larger area. A larger area could have many smaller areas connected to it Contains a reference to table 1 for the smaller areas and a reference to table 1 for the larger area. Example: 101 | 104 102 | 104 103 | 104 What I want to do is the following: The larger area should "inherit" the lowest value from the smaller areas that are connected to it. I want to be able to get all larger areas and let them have a value that is the lowest value from table 2. If you look at the example data I only want to get the larger area (104) from table 1 with a value from table 2 that is the lowest value of the areas connected to id 104. The result would be: 104 | 'LARGE area' | 'area name' | geom. | (value from table 2 id 102) Best regards, Mårten