On Friday 03 January 2003 11:57, Nuno Lopes wrote:
> I have a question about table relations and I would like you to help me.
> I have two tables in one server. The first tables has the following fiels:
> music_id; title; artist_id; chords
> The second one: artist_id; artist_name; country
>
> How can I JOIN this tables?? (I'm working in PHP, if it's matters).
> I want to print all musics from a specific country (first table) using the
> artist in second table. Can you help me building the SQL statement, please?
I hope these sections of the MySQL manual will help you:
http://www.mysql.com/doc/en/Multiple_tables.html
http://www.mysql.com/doc/en/JOIN.html
http://www.mysql.com/doc/en/SELECT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
