Hi everybody, 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? Thanking in avance, Nuno Lopes --------------------------------------------------------------------- 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
