What is inner and outer join and what is left inner and left outer join?
Answers
Answered by
1
Image result for What is inner and outer join and what is left inner and left outer join?stackoverflow.com
Inner join - An inner join using either of the equivalent queries gives the intersection of the two tables, i.e. the two rows they have in common. Left outer join - A left outer join will give all rows in A, plus any common rows in B.
Answered by
2
Answer:
(INNER) JOIN: Returns records that have matching values in both tables. LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table. RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table.
Similar questions