-- Select the film title and inventory ids SELECT f.title, i.inventory_id FROM film AS f -- Join the film table to the inventory table INNER JOIN inventory AS i ON f.film_id=i.film_id