469,090 Members | 1,100 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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

------=_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--
Jul 19 '05 #1
0 898

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Pejo | last post: by
1 post views Thread by Justin | last post: by
4 posts views Thread by Shahzad | last post: by
4 posts views Thread by bhargav.desai | last post: by
6 posts views Thread by davegb | last post: by
7 posts views Thread by Chris | last post: by
7 posts views Thread by Shanimal | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.