|
-
Apr 11th, 2010, 09:02 AM
#1
Thread Starter
Junior Member
Issue Comparing data in an sql server DB
i need to compare 2 tables in my database tutor and student
i have in student table: name, id , starting_schedule and finish_schedule gathering in there the time the student start a course and when the class finish for example if i have class from 8 - 10 it will say starting_schedule = 8 and finish schedule = 10 i need to compare all the schedules in the table with the available time in tutor table for example i have in student 8 - 10 11-12 1-2 and i have in tutor available_Time = 9 available_Time = 10 available_Time = 11
that mean tutor is available at 9 available at 10 and 11
how can i compare the info i have so i know if i can put that student in tutoring at that time?
*sorry for my english
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|