Mercurial > dive4elements > river
view flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 5529:52876daf97b0
Use left join on time intervals as they can be NULL
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 02 Apr 2013 13:02:12 +0200 |
| parents | 7a68967ca72a |
| 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