Since you're interested in unmarked assignments, it may make sense to use assign_submission as your base table, look for rows where the status = 'submitted', and do an outer join with assign_grades on assignment and userid. You'll of course have to filter further using the userid, context and role stuff.
Re: Retrieve all unmarked assignments for a particular teacher
by Olumuyiwa Taiwo -
Number of replies: 0