Multiple object pointer fields

[Ruslan Zasukhin]

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]