SAP hana difference in query output which has same objective

[Former Member]

Hi,

please help

we have seen the difference in record count for the different pattern query but with same objective

Query Joins are same but output is different which is strange

Query 1:

select count(EKPO."BANFN") from "RD2"."EBAN" EBAN inner join "RD2"."EKPO" EKPO on EKPO."BANFN" = EBAN."BANFN" and EKPO."BNFPO" = EKPO."BNFPO"

Query 2:

select count(EKPO2."BANFN") from "RD2"."EBAN" EBAN inner join ( select * from "RD2"."EKPO" )EKPO2 on EKPO2."BANFN" = EBAN."BANFN" and EKPO2."BNFPO" = EBAN."BNFPO"

KINDLY HELP

Regards.

Arun

+91 9920 813 801

[Former Member]

Surprisingly !! issue resolved after entering these two queries in procedure and now its giving equal output 🙂

SAP HA--NA