CREATE TABLE tracks (name VARCHAR2, genre_id VARCHAR2)
CREATE TABLE albums (id VARCHAR2, title VARCHAR2)

List name of all tracks in Balls to the Wall.
SELECT T2.name FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.genre_id WHERE T1.title = "Balls to the Wall"
SELECT "T2"."name" FROM "albums" "T1" JOIN "tracks" "T2" ON "T1"."id" = "T2"."genre_id" WHERE "Balls to the Wall" = "T1"."title"