Subject Re: [firebird-support] Select with calculated field problem
Author Svein Erling Tysvær
Post date 2017-11-28T17:08:15Z
Your actual result indicates that there are other rows in either of the tables (e.g. you could have an extra row in X01 with CODSBB 3 and CANT 1). Verify that these two queries return one row each:

SELECT *
FROM LSUBANS
WHERE CODSUB = 'SB3'

and

SELECT *
FROM X01
WHERE CODSBB = 'SB3'

HTH,
Set

2017-11-28 15:38 GMT+01:00 Laurentiu Anisie alaurentiu@... [firebird-support] <firebird-support@yahoogroups.com>:


I don't have null's.

On Tue, Nov 28, 2017 at 4:27 PM, LtColRDSChauhan rdsc1964@... [firebird-support] <firebird-support@yahoogroups. com> wrote:
 

Please check if you have null values.
Regards, 
Rajiv

On 28 Nov 2017 7:05 pm, "alaurentiu@... [firebird-support]" <firebird-support@yahoogroups. com> wrote:
 

Hi,


I have 2 tables and I want to select some data from them based on a common records. In the query, one of the column must be calculated as product of one field from table 1 and one field from table 2.

When I run the query, i get one row with the data without calculation, and one with calculation


The query is this:


SELECT A.CODSUB, A.CODOB, A.CODSBB, A.CANT*B.CANT FROM LSUBANS A,X01 B

WHERE A.CODSUB=B.CODSBB


LSUBANS

CODSUB  CODOB  CODSBB  CANT

SB3               EL8                         3


X01

CODSUB  CODOB  CODSBB  CANT

SB4                            SB3             3


the result of query had to be:

CODSUB  CODOB  CODSBB  CANT

SB3               EL8                         9


instead is:

CODSUB  CODOB  CODSBB  CANT

SB3               EL8                         3

SB3               EL8                         9


What I do wrong?


Thanks