CREATE TABLE torrents (groupname CLOB, totalsnatched NUMBER, artist CLOB, groupyear NUMBER, releasetype CLOB, groupid NUMBER, id NUMBER)
CREATE TABLE tags (index NUMBER, id NUMBER, tag CLOB)

Which tag is used for which release title?
SELECT T1.tag, T2.groupname FROM torrents AS T2 JOIN tags AS T1 ON T1.id = T2.id
SELECT "T1"."tag", "T2"."groupname" FROM "torrents" "T2" JOIN "tags" "T1" ON "T1"."id" = "T2"."id"