Caterpillar Inc Full Stack Software Developer Interview Questions and Answers

SQL joins (Inner, Left, Right, Full) are used to combine rows from two or more tables based on a related column between them.

• Inner join: Returns rows when there is at least one match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full join: Returns rows when there is a mat