Nuno Lopes Try this:
SELECT music_id, title, artist_name, country FROM music_table, artist_table WHERE music_table.artist_id = artist_table.artist_id AND country LIKE 'desired country' Anderson Ataides Em Sex 03 Jan 2003 07:57, you wrote: > 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 --------------------------------------------------------------------- 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