Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT Are_Number, SUM(EWjeAdr)
  2. FROM BereichBerechnung
  3. JOIN EW_Data
  4. ON BereichBerechnung.ogr_geometry.STContains(EW2017.ogr_geometry) = 1;
  5. GROUP BY Are_Number
  6.  
  7. SELECT Are_Number, SUM(EWjeAdr)
  8. FROM BereichBerechnung
  9. JOIN EW_Data
  10. ON contains(BereichBerechnung.geometry, EW_Data.geometry)
  11. GROUP BY Are_Number
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement