given a statement like

select * from mytable where id=1
[download]

if you want to extend your search to more then one id, but a list obtained from another query, you can

select * from mytable where id in (select id from table2)
[download]

As you can see, it's related to your db and not all dbms support it.

If i understood well, you want to "narrow" your search to a limited subset of artists, having no more data i'll write an example:

select * from album where artist in (search artistId in artists where 
+year = 1990)
[download]

Note that you can convert the IN clause with a INNER JOIN:

select album.* from album a, artists b where a.artist = b.artistId and
+ b.year = 1990
[download]

HTH

Oha