SQL ? What are the different joins ? Examples of joins by given scenario?

Question

Accepted Answer

Explanation of SQL joins and examples

Inner join: returns only matching rows from both tables
Left join: returns all rows from left table and matching rows from right table
Right join: returns all rows from right table and matching rows from left table
Full outer join: returns all rows from both tables
Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Example: Left join - SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.column
Example: Right join - SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column
Example: Full outer join - SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.column = table2.column

Top Onward Technologies Inc K2 Developer interview questions & answers