Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query regarding inner join

Hi,

I have below two tables.

table1

IDDesc
1abc
2def
3ghi
4jkl

table2

IDRevenue
1100
1200
1300
2400
2401
2402
3403
3404
3405
4406
4407
4408

i have executed below query.

select t."ID",t."Desc",t1."Revenue"

from "table1" as t

inner join "table2" as t1

on t."ID" = 1.0;

Result:

So my question is why its fetching records from table2 in which ID <> 1?

It should only fetch records from table 2 where ID = 1 only.

I think I am lacking my understanding in case of joins somewhere.

Please explain.

BR

Sumeet

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question