Sql

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Henry Olive Fri, 06 Dec 2002 18:36

#11171

Author: 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.

Re: Sql

#11173

Author: 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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads