Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!cs.utexas.edu!uunet!dev!dgis!jkrueger
From: jkrueger@dgis.dtic.dla.mil (Jon)
Newsgroups: comp.databases
Subject: Re: Ease of SQL with an ugly schema
Message-ID: <934@dgis.dtic.dla.mil>
Date: 20 Jul 90 02:03:46 GMT
References: <10698@chaph.usc.edu> <10115@sybase.sybase.com>
Organization: Defense Technical Information Center (DTIC), Alexandria VA
Lines: 11

jeffl@sybase.Sybase.COM (Jeff Lichtman) writes:

>	select (select sum(X - Y) from TAB where FLAG = 0) +
>		(select sum(X + Y) from TAB where FLAG = 1)

An excellent solution, except it isn't what the question asked for, SQL.

-- Jon
-- 
Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
Drop in next time you're in the tri-planet area!