Joins

##### Title

##### Question

What is the difference between cartesian and inner joins?

RDBMS-PostgreSQL General

__Answers:__

The topics under joins are not yet covered in our series.

Please refer to the link below for more information.

https://www.geeksforgeeks.org/sql-join-cartesian-join-self-join/

The main difference between Cartesian and Inner joins lies in their functionality and the results they produce:

__):A Cartesian join returns the Cartesian product of the two tables involved.It combines every row of the first table with every row of the second table, resulting in a potentially large number of rows in the output.There is no specific condition used to join the tables; instead, it generates a row for every possible combination of rows from the two tables.It is used when you want to generate all possible combinations between two tables.__

**Cartesian Join (Cross Join**__:An inner join returns only the rows from both tables that satisfy the join condition.It selects only the rows from both tables where the join condition evaluates to true.Inner join is the most common type of join and is used to retrieve rows that have matching values in both tables.The join condition typically involves comparing the values of one or more columns from each table.__

**Inner Join**
Login to add comment