What you’ll learn in this Chapter
✓ What is a Join
✓ Types of Joins
✓ Cartesian Product vs Joins
✓ ANSI Joins
Overview
Relation between tables is the core concept in RDBMS. We recommend you to go through our RDBMS Course for better clarity on concepts.
Oracle JOIN is used to retrieve data from multiple tables, views or materialized views. In SQL, a JOIN is performed whenever multiple tables appear in queries FROM clause.