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

a lot Roger! Babale -Ursprüngliche Nachricht- Von: Roger Baklund [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 16. August 2003 14:32 An: [EMAIL PROTECTED] Cc: B. Fongo Betreff: Re: How many join do I need for a query on 3 table? * B. Fongo > I was able to extra the information from the

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

* B. Fongo > 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" > > -

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

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" --