Need _HELP_ with Report!

[Krista]

Hi,

 

I need to send a file, perhaps an excel file, (or the packing slips would be great even if they contained the entire order rather than just the one item that was being shipped by this vendor) with a list of all the orders of a t-shirt on my site, with the sizes order and quantities, to the company that printed and is going to ship my t-shirts for me.

 

How can I make a report that will do this? I've tried this, but it's not accurate:

 

SELECT orders.orders_id, orders.delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_country, delivery_postcode, products_name, products_options_values

FROM orders, orders_products, orders_products_attributes

WHERE orders.orders_id = orders_products.orders_id AND orders.orders_id = orders_products_attributes.orders_id AND products_name = 'March Fitted (Baby) T-Shirt' order by orders.delivery_name"

 

I need to send this to them Today! Please help!

 

Krista