Joining tables is the most important distinction between relational database and other DBs
Join is performed when data are retrieved from more than one table at a time
Equality comparison between foreign key and primary key of related tables
Join tables by listing tables in FROM clause of SELECT statement
DBMS creates Cartesian product of every table