I tried unsuccessfully to get line level information regarding a specific command but I receive the header information.
Look at this picture:
This is my request:
select o.increment_id, o.status, oi.price_incl_tax, t.carrier_code, o.created_at, oi.price_pvp, oi.created_at, o.shipping_instruction, o.payment_term from sales_flat_order o join sales_flat_order_item oi on o.entity_id = oi.order_id left join sales_flat_shipment_track t on o.entity_id = t.order_id where oi.parent_item_id is null
What's wrong? Can you help me solve this problem?