Query with inner join (Help!)

[B. Fongo]

Hello!

I ' m trying to extra some information from 2 tables using inner join,
but receive an error warning.  Am newbie so I' m not able to feature out
why my queries don't work.

Scenario:

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


All that am trying to get out of these tables is to use a cust_id of a
given customer to extract their orders. So I use something like this:

SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from
Customers WHERE cust_id = 2 inner join Orders ON Customers.cust_id =
Orders.cust_id

Can anyone help me on this?

Thanks