sql advice

[Ruslan Zasukhin]

On 1/24/06 4:12 PM, "Chris Sheffield" <cmsheffield at gmail.com> wrote:

> Still no go unfortunately.  This only returns the teachers and
> classes that have students.  As you said, I need all teachers and
> classes, whether they have students or not.
> 
> I know this seems like it should work, but it doesn't unless I remove
> the SchoolYear condition.  But I need to be able to filter the
> records by SchoolYear, otherwise I'm in trouble.

IF you want please send db to Ivan.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]