Mercurial > hg > tema

view dist/biotopes/class.sql @ 0:1d2fe61a3a62

find changesets by author, revision, files, or words in the commit message
Tema 0.1 (imported from CVS).
author Mikhail Kryshen <mikhail@kryshen.net>
date Tue, 16 May 2006 18:04:09 +0400
parents
children
line source
1 SELECT t1.*
2 FROM biotopelist AS t1
3 WHERE rusname AND Right(t1.rangcode, 8) = '00000000'
4 AND EXISTS
5 (SELECT NULL FROM biotopelist AS t2
6 WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1)
7 AND Right(t2.rangcode, 8) <> '00000000')