A Cartesian join is an (incorrect) join between two tables. Incorrect because the tables have not been joined in any relational format.

Select street_address from authors a, location b where  a.last_name like ‘%varma%’

Since the tables have not been paired using a common relational column,  

SQL Server will multiply all the rows of table A with table B. This is called a Cartesian Join.

Other Bad Joins

Hash Joins, Merge Joins, Nested Loop Joins.

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.

 Twitter Linkedin