Here are 2 .xlsx files one for our orders and one for the stops, when you look through the stops you'll see there are 2 order_id's for each which match...

so that displays correctly as far as showing all of the data, thank you for that, but perhaps my join isn't correct as  for each order there are 2 stops,...

I don't believe I'm going to be able to provide the data readily, I'm basically just trying to find out if there is a way to display the pickup and...

select orders.rate, stop.actual_departure, stop.city_name, stop.state, stop.order_id ,
CASE when stop.stop_type = 'PU' then city_name
    end as pickup

from orders
RIGHT OUTER JOIN stop ON orders.id =...