RE: Problem with NULL values
From: Rekaish Bhardwaj <RekaishB@compans.com>
>
>I think you have to do it in two hits. Try
>
>SELECT ordernro, quantity, sent, (quantity - sent ) as 'q_left'
>FROM orders
>WHERE sent is not null
>UNION
>SELECT ordernro, quantity, sent, (quantity) as 'q_left'
>FROM orders
>WHERE sent is null
You want to read a manual, mate. Otherwise people spend weeks taking the
p1$$ out of you. :-)
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com