Posted By: JiMo (I'm flyiiiiiiing!!!!!!!!!) on 'CZdatabases' Title: Re: jak poskladat dotaz Date: Sat Oct 25 01:14:42 2008 Dekuji bukaJovi za tip, ktery po drobne uprave prosel: select jednotka from ( select DISTINCT jednotka, faze, stav from table where (faze=2 and stav=1) or (faze=1 and stav=3) or (faze=3 and stav=3) group by jednotka, faze, stav ) sub group by jednotka having count(jednotka) = 3; ...tohle bych dneska z hlavy fakt nedal. :) Jeste jednou dekuju. jimo:) ...dite tak dlouho posloucha, jak mu vsichni rikaji ta-ta, ta-ta, ta-ta, az se nastve a rekne "tata". ([driv tady byla signatura, kterou stejne asi uz nikdo nechapal])