Is this better:

select orders.orderid, orders.shipvia, order_details.productid, shippers.companyname from order_details join orders on order_details.orderid=orders.orderid join shippers on...