how to get the columns from multiple tables into a single qu

Question

I m doing a online shopping website and in dat I want a page dat fetches the order history of a customer but problem is the order table do not contain customer id and i want the customer id should be selected from customers table should I use nested query...plz any suggestion?