Sql

Article View: borland.public.interbase.sql

Article #11171

Back to borland.public.interbase.sql Previous Next

#11171

From: Henry Olive
Date: Fri, 06 Dec 2002 18:36

15 lines
1429 bytes

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.

Technical Details

Message-ID: <3df0edef@newsgroups.borland.com>

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!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.netcom.net.uk!netcom.net.uk!news.tele.dk!news.tele.dk!small.news.tele.dk!news-fra1.dfn.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,6bb89a133a128aba,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-06 10:39:59 PST
From: "Henry Olive" <zed@zedltd.com>
Newsgroups: borland.public.interbase.sql
Subject: Sql
Date: Fri, 6 Dec 2002 20:36:11 +0200
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 195.175.163.245
Message-ID: <3df0edef@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039199727 195.175.163.245 (6 Dec 2002 10:35:27 -0800)
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!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.netcom.net.uk!netcom.net.uk!news.tele.dk!news.tele.dk!small.news.tele.dk!news-fra1.dfn.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail