In the following query, my eventual goal is to get output that looks something like this: 0 | 13744878, 8523154, 8600448, 2721809 1 | 34682, 63211, 6083615 mysql> SELECT pl_from, page_id FROM pagelinks INNER JOIN page ON pagelinks.pl_title = page.page_title; +---------+----------+ | pl_from | page_id | +---------+----------+ | 0 | 13744878 | | 0 | 8523154 | | 0 | 8600448 | | 0 | 2721809 | | 1 | 34682 | | 1 | 63211 | | 1 | 6083615 | +---------+----------+