AW: Query with inner join (Help!)

[B. Fongo]

------=_NextPart_000_0011_01C36322.2FEF5DC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It works!=20
SELECT Customers.Name, Customers.City, Orders.Product, Order.Price
FROM Customers INNER JOIN Orders ON Customers.cust_id =3D Orders.cust_id
WHERE cust_id =3D 2;

Thanks a lot.

-----Urspr=FCngliche Nachricht-----
Von: Egor Egorov [mailto:eg*********@ensita.net]=20
Gesendet: Freitag, 15. August 2003 10:14
An: my***@lists.mysql.com
Betreff: Re: Query with inner join (Help!)

"B. Fongo" <my****@fongo.de> wrote:

=20
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.
=20
Scenario:
=20
I have 2 tables: Customers and orders. The have following structures:
Customers Orders
cust_id Product
Name Price
City cust_id
=20
=20
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:
=20
SELECT Customers.Name, Customers.City, Orders.Product, Order.Price from Customers WHERE cust_id =3D 2 inner join Orders ON Customers.cust_id = =3D Orders.cust_id
=20
Can anyone help me on this?

SELECT Customers.Name, Customers.City, Orders.Product, Order.Price
FROM Customers INNER JOIN Orders ON Customers.cust_id =3D
Orders.cust_id
WHERE cust_id =3D 2;

--=20
For technical support contracts, goto
https://order.mysql.com/?ref=3Densita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Eg*********@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmy****@fongo.de
------=_NextPart_000_0011_01C36322.2FEF5DC0--