SELECT Duplicate Records with Matching IDs

So painfully simple, but I can never remember this when I need it, so here it is!

SELECT l.fileid, l.title, a.title
FROM pub_books AS l
JOIN books AS a
ON l.fileid = a.fileid