Retrieving Data from Child Table

Hi Experts,

I have the following 2 table structures:

Deliveries
date
pickup_location
dropoff_location

Both locations are ints related to the following table

Location
id
name

Now, my question is how can I get the date, pickup location id, pickup location name, dropoff id and dropoff name within 1 query?

Thank you