Dear Chris,
look here: http://www.mysql.com/doc/J/O/JOIN.html
It's one of the JOINs (INNER JOIN or LEFT JOIN) you are looking for.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Chris Malloch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 10:54 AM
Subject: Tables relationships
> Hi folks,
>
> Can someone please point me in the right direction to let me know how
to
> define a relationship between tables in MySQL eg one-to-many. I
haven't
> come across it in the manual yet, but am sure it must be there
somewhere.
>
> Many thanks in advance,
>
> Chris Malloch
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
