Re: need help with sql

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 03 Mar 2005 08:20:48 -0800
Message-ID: <1109866658.160730@yasure>

Starton X. Mangrove wrote:

> Sorry, Im majorly stressed out due to a deadline. I sincerely apologize for
> saying all that.

If you can say it twice ... I'll back off. Apology accepted.

Seriously ... you were given two workable solutions. Your original post described two situations ... some column = 0 or it doesn't. You can use decode to solve it or you can put together two separate queries as I indicated and UNION or UNION ALL them together: Either will work.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Mar 03 2005 - 10:20:48 CST