sql advice

Tue Jan 24 00:20:21 CST 2006

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

> Thanks, Ruslan.  But isn't this sql syntax only supported with
> Valentina 2, or am I mistaken?

Ak, you are on 1.x ?
Sorry, I have not realize that

Then still you can translate last my form to 1.x style

Just I wonder why you have so many outer joins

It seems to me these 3 should be simple inner joins.

>         JOIN StudentClass scl ON c.recID = scl.ClasPtr
>         JOIN StudentYear sy ON scl.StudentYearPtr = sy.recID )
>             JOIN Students s USING sy.StudentPtr = s.recid )

-- 
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]