some simple queries could you help? PLEASE
how do i find the subject which has taught within last 5 days?
Subject table holds Sub_ID, sub_name
Lesson holds Les_ID, sub_ID, Lesson_Taken place
SELECT sub_ID, subject
FROM Subject
WHERE date FROM Lesson > 1-4-11 AND < 16-4-11?
Would this be correct?
THANKS!!!!
No comments:
Post a Comment