Select Code to Download

select * from mytable where id=1

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

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

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