Re: [GENERAL] simplifying SQL

2007-02-08 Thread Richard Huxton
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

[GENERAL] simplifying SQL

2007-02-07 Thread garry saddington
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 distinct(studentclass.studentclassid),classes.subject,studentclass.studentid as classstudent,classes.te