SQL inner join

[Freddicola]

DB source: https://www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/

table: rental

table: inventory

table: film

[Freddicola]

rental_id == 2 정보 얻기

select 
    *
from 
    rental
inner join 
    inventory 
    on inventory.inventory_id = rental.inventory_id
where 
    rental.inventory_id = 2

select 
    *
from 
    rental
inner join 
    inventory 
    on inventory.inventory_id = rental.inventory_id
inner join
    film
    on inventory.film_id = film.film_id
where 
    rental.inventory_id = 2