Multiple object pointer fields

[Chris Sheffield]

Okay, so I need my head examined.  I knew it would end up being  
something obvious.  :-)

Thanks Ruslan.

Chris

On Sep 16, 2005, at 11:32 AM, Ruslan Zasukhin wrote:

> On 9/16/05 7:42 PM, "Chris Sheffield" <cmsheffield at gmail.com> wrote:
>
>
>> Anyway, with my new table I still can't seem to get the query right,
>> and maybe it's just because I'm not sure how the SQL should be for
>> Valentina.  I keep getting a 616 wrong expression error.  This is
>> just a simple test query that I'm running using ViSQL:
>>
>> SELECT Teachers.LastName, Classes.ClassName, Students.LastName FROM
>> Teachers, Classes, Students WHERE
>> Students.RecID=TeachStuInt.StudentPtr AND
>> TeachStuInt.TeacherPtr=Teachers.RecID
>>
>> Why does this give me the 616 error?  Can anyone help?  What is
>> proper syntax for a query dealing with a many-to-many relationship?
>>
>
> SELECT Teachers.LastName, Classes.ClassName, Students.LastName
> FROM
>     Teachers, Classes, Students
> WHERE
>     Students.RecID = TeachStuInt.StudentPtr
> AND
>     TeachStuInt.TeacherPtr = Teachers.RecID
>
>
> You have not specify table TeachStuInt in the FROM clause,
> But use it.
>
>
> -- 
> 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
------------------------------------------