|
mrdatabase
Starting Member
United Kingdom
12 Posts |
 Posted - 04/29/2012 : 06:22:30
|
I have two seperate SQL's here and i just want one SQL code
They are
SELECT Forename, Surname, Sum(Likes) AS Total_Amount_Of_Likes
FROM Instructors, Exercise_Class_Type, Exercise_Class_Staff, Exercise_Class_Booking, Feedback
WHERE Exercise_Class_Type.Exercise_Class_ID = Exercise_Class_Staff.Exercise_Class_ID
AND Exercise_Class_Type.Exercise_Class_ID = Exercise_Class_Booking.Exercise_Class_ID
AND Exercise_Class_Booking.Exercise_Booking_ID = Feedback.Exercise_Booking_ID
AND Instructors.Instructor_ID = Exercise_Class_Staff.Instructor_ID
AND Start_Date_Time >= Date() - 30
GROUP BY Forename, Surname;
SELECT Forename, Surname, Total_Amount_Of_Likes
FROM Report_F
WHERE Total_Amount_Of_Likes = (SELECT MAX(Total_Amount_Of_Likes)
FROM Report_F);
The second SQL basically finds the max amount of likes an instructor has, is it possible to have this all in a single code via a sub query?
I am writing it in Access
Thanks
|
|
Two Seperate SQL's. I want just one code
