Changed around order of join so that courses with no TA's will still be included (they didn't appear in the assignedTo table obviously).