sql order query

SELECT * FROM sales_flat_order_item t inner join sales_order s on s.entity_id =t.order_id where customer_id='1';