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 q
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; cou
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 i
