Re: Sql

Article View: borland.public.interbase.sql

Article #11173

Back to borland.public.interbase.sql Previous Next

#11173

From: Aage Johansen
Date: Fri, 06 Dec 2002 20:47

25 lines
1566 bytes

Henry Olive wrote:
> 
> D6, IB6
> 
> SELECT  P.PARTNO,  P.PARTNAME,
> SUM ( D.SUMSELL + P.INVVALUE - D.SUMBUY) BEN
> FROM  DETAIL D ,  PARTS  P
> WHERE ( P.PARTNO = D.PARTNO )
> GROUP BY  P.PARTNO ,  P.PARTNAME
> ORDER BY 3 DESC
> 
> ( SumSell & SumBuy are regular field ( Not calc.) in detail table )
> PartNo , PartName fields are OK.They can be seen in the result
> But I get an empty column for BEN field ( with no error )
> what is the problem ?
> 
> Thank You.


Maybe one or more of D.SUMSELL, P.INVVALUE, D.SUMBUY are Null ?
(assuming you get any rows at all)


--
Aage J.

Technical Details

Message-ID: <3DF10CEB.3F2A73CD@offline.no>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newspump.sol.net!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail

References: <3df0edef@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,6bb89a133a128aba
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-06 13:15:24 PST
Message-ID: <3DF10CEB.3F2A73CD@offline.no>
Date: Fri, 06 Dec 2002 21:47:39 +0100
From: Aage Johansen <aagjohan@offline.no>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Sql
References: <3df0edef@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 80.212.44.202
X-Trace: newsgroups.borland.com 1039209154 80.212.44.202 (6 Dec 2002 13:12:34 -0800)
Lines: 27
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newspump.sol.net!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message