It looks innocent enough, but apparently I'm structuring something incorrectly.

SELECT u.firstname, u.lastname, n.nID, n.date, n.priority, n.type, n.sender, n.recipient, n.subject, n.message FROM users u, notifications n WHERE n.sender = u.email order by priority limit 5

Thanks!