Re: table relations

2003-01-03 Thread Anderson Pereira Ataides
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 relati

re: table relations

2003-01-03 Thread Egor Egorov
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