Question

Explain SQL join and it's types

Answer 1

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