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])