Skip to Content
avatar image
Former Member

SAP hana difference in query output which has same objective

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 20, 2017 at 05:24 AM

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

    SAP HA--NA

    Add comment
    10|10000 characters needed characters exceeded