I have two tables
table one has three column
Student Name Studentcourse StudentID Date
xyz java 123 2009-10-15 15:10:00
abc c 456 2009-10-17 09:00:00
uvw sql 789 2009-10-18 16:00:00
jkg sql 000 2009-10-15 18:10:00
I need help with the query where we can get student who have taken sql on 15 of oct but where not graded that is not found table two.
I have come up with this query
from tabletwou ,tableone au
where au.Studentcourse='sql' and au.date
between '2009-10-15 00:00:00' AND '2009-10-15 23:59:59'and u.StudentID=auStudentID;
but I am getting wrong result...