SQL INNER JOIN

Joining tables together usually means combining them based on a shared column called a foreign key.

Most of the time, the default join is an inner join. Here is a great explanation of the difference between left, right, inner, and outer joins.

select tenants.name as tenant_name, rent_payments.payment_date, rent_payments.dollar_amount from rent_payments inner join tenants on rent_payments.tenant_id = tenants.id;

Input tables

tenants table

id name
1 Albert
2 Marie
3 Jose
4 Terrell

rent_payments table

tenant_id building_id payment_date dollar_amount
1 1 3/1/2018 2000
2 1 3/2/2018 1500
3 2 3/1/2018 1800
4 2 3/3/2018 1900
1 1 4/2/2018 2000
2 1 4/2/2018 1500
3 2 4/1/2018 1800
4 2 4/2/2018 1900

Query results

tenant_name payment_date dollar_amount
Albert 3/1/2018 2000
Marie 3/2/2018 1500
Jose 3/1/2018 1800
Terrell 3/3/2018 1900
Albert 4/2/2018 2000
Marie 4/2/2018 1500
Jose 4/1/2018 1800
Terrell 4/2/2018 1900