How we join the tabels and types of join

Question

Accepted Answer

Joining tables is done using JOIN keyword. Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

JOIN keyword is used to combine rows from two or more tables based on a related column between them.
INNER JOIN returns only the matching rows from both tables.
LEFT JOIN returns all rows from the left table and the matching rows from the right table.
RIGHT JOIN returns all rows from the right table and the matching rows from the left table.
FULL JOIN returns all rows from both tables, including unmatched rows.
Examples: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.column;
SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;
SELECT * FROM table1 FULL JOIN table2 ON table1.column = table2.column;

Accepted Answer

We are join the tabels by using unique identifier and types are inner join, full join, left join, right join

Popular interview questions of Oracle SQL and PLSQL Developer