Posted By: dzemen () on 'CZdatabases' Title: Re: jeden kontrolni select Date: Fri Sep 8 14:42:49 2006 > Pokud Ti nevadi, ze to pripadne prekryvy vypise vickrat, tak muzes pouzit > tohle : > select * from prekryv a, prekryv b > where a.id=b.id and not a.rowid=b.rowid > and ((b.od between a.od and a.do) or (b.do between a.od and a.do)) > order by 1,2,3 Grrrr!!!! Uz zase jedna Oracle-only rada ! :-((( To ten: select t.id from rv_proh_xml t where exists ( select id from rv_proh_xml a where a.from_ between t.from_ and t.to_ or a.to_ between t.from_ and t.to_ ) bude aspon fungovat vsude (SQL92 kompatibilni). Mimochode tusim Jimo se tu ptal, co je to to "t" na 1. radce vyrazu a "a" ve 3. radce. Tak to jsou aliasy te tabulky rv_proh_xml (jde o to, ze je v tom dotazu pouzita 2x a musi se to nejak odlisit....) Dzemen