garry saddington wrote:
I have this query which essentially returns records that exist in one table (studentclass) and not another (effortandattainment) to check when teachers have entered their student grades. select
from studentclass left join effortandattainment
and studentclass.classid not in (
I was wondering whether a simpler method exists to do the same thing or is this OK.
The formatting on the query isn't great, but I can't quite see what the "left join" is doing with the "not in" too. I'd probably just have the left join and check that "effortandattainment.classid IS NULL".
-- Richard Huxton Archonet Ltd
