Select DISTINCT COURSE.ID, COURSE.NAME, COURSE.CATEGORYID, COURSE.DESCRIPTION " +
"COURSE.GRADELEVELS, COURSE.OWNERID from MEETING, COURSE, INSTRUCTOR " +
"Where INSTURCTOR.ID = 1 And COURSE.INSTRUCTORID = INSTRUCTOR.ID And " +
"Meeting.COURSEID = COURSE.ID And MEETING.STARTDATE <= CURRENTDATE <= MEETING.ENDDATE"
Basically I am trying to get the Courses from the course table where CURRENTDATE is between Meeting.STARTDATE AND Meeting.ENDDATE. CURRENTDATE is of type java.sql.Date. Am I comparing the dates correctly ? ie. can i use logical operators or is there a function in mysql to compare the DATES ?
Thanks.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
