select * from mytable where id=1

##</code><code>##

select * from mytable where id in (select id from table2)

##</code><code>##

select * from album where artist in (search artistId in artists where year = 1990)

##</code><code>##

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