Join query

Hello Team,

I have query :slightly_smiling_face:

Table 1 has 2 rows : Table 2 has 2 rows
1 1
1 1

If we apply Inner Join between these 2 tables then what will be result

And if we apply left outerjoin.Then what would be the result.


In this case, INNER JOIN and LEFT OUTER JOIN will produce the same results: two rows with all columns from both tables.