MySQL subqueries

[rlwebb]

I am trying to use a subquery to pull out the names of the four members of the band coldplay, which is grp_id 1 in table joins. I can get the artist ID from joins, but then I need the artist table to link over to the member's name. Anyone tell me what's wrong with my query? Thanks.

mysql> SELECT art_name FROM artist WHERE art_id IN (SELECT art_id FROM joins WHERE
 grp_id=1);

 

[giacomo]

I don't see anything wrong with your SQL, are you getting an error when you run it?

You don't need a sub-query for this, this should work fine:

SELECT 
a.art_name 
FROM 
artist a
, joins j
WHERE a.art_id = j.art_id
AND j.grp_id=1;

hth,
Giacomo