Query with inner join (Help!)

[B. Fongo]

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

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
------=_NextPart_000_0007_01C36311.DEE8D2E0--