Skip to Content
0

SAP hana difference in query output which has same objective

Mar 10, 2017 at 07:59 AM

14

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Gupta Mar 20, 2017 at 05:24 AM
0

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

SAP HA--NA

Share
10 |10000 characters needed characters left characters exceeded