How do I solve this problem?

[Tsung90]

Hi, at the moment I have this query:

SELECT Feedback, Exercise_Class_ID, Count(*) AS Total_Per_Exercise_Instructor
FROM tblExerciseClass
WHERE (((tblExerciseClass.Feedback) Between '0' And '1')) AND (((tblExerciseClass.Date_Exercise_Class) Between '02/01/12' And '03/01/12'))
GROUP BY Feedback, Exercise_Class_ID;

I want to include the name of the exercise instructor from tblExerciseInstructor in the above query. The name of the field = Full_Name. In the tblExerciseInstructor, each Exercise_Class_ID represents an exercise instructor (i.e. EC00001 is taught by Thomas Howard). The query shown above is just from tblExerciseClass. How do I do this?

Many thanks.

 

[Tsung90]

I tried what you told me to do but it comes up with the error message 'the specified field 'Full_Name' could refer to more than one table listed in the FROM clause of your SQL statement'.