How many join do I need for a query on 3 table?

[B. Fongo]

------=_NextPart_000_0014_01C363E8.FDC5B160
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello again!

I was able to extra the information from the first 2 tables yesterday
using following query:

SELECT Customers.Name, Customers.City, Orders.Product,
Order.Price FROM Customers inner join Orders USING (cust_id) WHERE
customers.cust_id = "2"

------------------------------------------------------------------------
--------------------------------------------------------
SELECT Customers.Name, Customers.City, Orders.Product,
Order.Price FROM Customers inner join Orders ON
Customers.cust_id=Order.cust_id WHERE customers.cust_id = "2"
Right now I need credit card details from a third table; and that make
the query more complicated for me.
I' m not sure weather 2 inner joins could be used. I' ll appreciate any
help.

I have 2 tables: Customers and orders. The have following structures:
Customers Orders Payment
cust_id Product Order_id
Name Price Credit_Card
City cust_id
Order_id

Best Regards

Babs

------=_NextPart_000_0014_01C363E8.FDC5B160--