Jak to resit pomoci SQL ?

[Karel Zak]

On Tue, Mar 11, 2003 at 11:53:17AM +0100, Jan Serak wrote:
> Bez joinu:
> 
> SELECT name,sum(replace(isin,'t',data,'f',0)) as
> in,sum(replace(isin,'f',data,'t',0)) as out
>   from rule
>   group by name;

 Kdyby jen bez joinu, ale hlavne bez dvou sub-selectu :-)

    Karel

-- 
 Karel Zak  <zakkr na zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/