Greetings..
I have a problem with my sql. When i run the qeury it returns a "Type mismatch in expression" error.
Here's the code for your reference :
Is there anything wrong with the code? What I am trying to do is open a recordset that 3 tables has relations in.Code:SELECT [Tutorials].[TutorialID], [Tutorials].[TutorialTitle], [Tutorials].[AuthorID], [Tutorials].[DatePosted], [Tutorials].[CourseID], [Teachers].[TeacherID], [Teachers].[LastName], [Courses].[CourseID], [Courses].[CourseName], [Courses].[CourseLevel] FROM Courses INNER JOIN (Teachers INNER JOIN Tutorials ON [Teachers].[TeacherID]=[Tutorials].[AuthorID]) ON [Courses].[CourseID]=[Tutorials].[CourseID];
Thanks for any help in advance.




Reply With Quote