Query with inner join (Help!)

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

Re: Query with inner join (Help!)

Hi Fongo, http://www.mysql.com/doc/en/JOIN.html Should work like this (untested): SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from Customers, Orders WHERE Customers.cust_id = Orders.cust_id AND cust_id = 2 inner join Best regards Nils Valentin Tokyo/Japan 2003 8

Re: Query with inner join (Help!)

Customers inner join Orders USING (cust_id) WHERE customers.cust_id = 2 HTH. Regards Steve. - Original Message - From: B. Fongo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 15, 2003 8:44 AM Subject: Query with inner join (Help!) Hello! I ' m trying to extra some

Re: Query with inner join (Help!)

B. Fongo [EMAIL PROTECTED] wrote: 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:

AW: Query with inner join (Help!)

10:14 An: [EMAIL PROTECTED] Betreff: Re: Query with inner join (Help!) B. Fongo [EMAIL PROTECTED] wrote: 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

Re: Query with inner join (Help!)

Hi Fongo, Steve gave a perfect explanation ( and made me realize my and Egor's small mistake ;-) 2003 8 15 17:08Nils Valentin : Hi Fongo, http://www.mysql.com/doc/en/JOIN.html Should work like this (untested): SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from