What is the difference between “INNER JOIN” and “OUTER JOIN”?
Loading
What is the difference between “INNER JOIN” and “OUTER JOIN”?
2 Answers
It is used to get matching Data between two or more tables based on “ON” or “WHERE” condition. Only matching rows are returned.
Outer joins are joins that return matched values and unmatched values from either or both tables
Rajeev KumarPosted Mar 17, 2023, 10:25 AM
Inner Join
It is used to get matching Data between two or more tables based on “ON” or “WHERE” condition. Only matching rows are returned
Outer Join
It is used to get matching data from one table and all data form other.
Ishoo AnyalPosted Nov 12, 2020, 3:58 AM