Untitled

SELECT student.username "stu_user", student.fullname "stu_name",
        sup.username "sup_user", sup.fullname "sup_name",
        snd.username "snd_user", snd.fullname "snd_name",
        p.project_name, p.description
FROM users student, users sup, users snd, projects p, project_allocation pa
WHERE student.username = pa.student
  AND sup.username = pa.supervisor
  AND snd.username = pa.second_reader
  AND pa.project_id = p.project_id
  AND pa.allocation_id = {$aid}