sql advice

[Chris Sheffield]

Okay, I'll give that a try.  Thanks.


On Jan 23, 2006, at 3:20 PM, Ruslan Zasukhin wrote:

> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

------------------------------------------
Chris Sheffield
Read Naturally
The Fluency Company
http://www.readnaturally.com
------------------------------------------