Mercurial > dive4elements > river
view etl/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 8047:c835f3cf098e
Sediment load: Added join to fetch measurement station via ranges which know the river. Added a visitor for values, too.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Thu, 17 Jul 2014 11:19:59 +0200 |
| parents | 5aa05a7a34b7 |
| children |
line wrap: on
line source
select.abflusstafel = \ SELECT ABFLUSSTAFEL_NR, \ ABFLUSSTAFEL_BEZ, \ GUELTIG_VON, \ GUELTIG_BIS, \ PEGELNULLPUNKT, \ AT.BFG_ID \ FROM ABFLUSSTAFEL AT \ WHERE MESSSTELLE_NR LIKE :number