Need Help Writing Query to export all information about an Order #

[ilikefastfood]

I need help writing a query so that once I have the order number, I can quickly export all information regarding the order. In short, I am having difficulty with use of the "Join" command.

 

What I am trying to do is join together the information from the following tables for orders_id = x

 

orders

orders_products

orders_products_attributes

orders_status_history

orders_total

ups_tracking

 

I can always clean this data up after I've opened the table in Excel.

 

Thanks in advance for your help.