Re: simplifying SQL

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