I think I found an easier/accurate solution (YouTube video name below - I can't include links). I basically ran a query in phpMyAdmin combining the two tables, then exported the results. Hope it helps.

'MySQL tutorial 15 - joining 2 tables'