Posted By: JiMo (I'm flyiiiiiiing!!!!!!!!!) on 'CZdatabases' Title: Re: jeden kontrolni select Date: Mon Sep 11 19:38:00 2006 Yabadabadoooooooooo! :))) Tak tedy to "oracle-only" reseni vesele beha, tedy v uprave select * from TABULKA A, TABULKA B where A.ID=B.ID and not A.IDT=B.IDT and ((B.OD > A.OD and B.OD < A.DO) or (B.DO > A.OD and B.DO < A.DO)) order by A.ID ; Musim rict, ze to na pomerne vykonnem serveru chroustalo pres pet minut, ale je to ono! Dekuji, dekuji... pokud se mi podari dotvorit ten prvni tvar (s exist), muzu dat vedet, co je efektivnejsi. :) JiMo:) CONNECT 300^M .....OP^aFD)*HR!hT%UJ0~~!aS&RT&*WQ$*brI&FG^NO CARRIER