Bigeyes

My project is switch the direction so I will say this problem is solved. Thanks again Wildbug

Yes, I also want to display the one that is not follow the template and how are they different compare to the template. Thank you for your time. I will try during the week.

I would like to thank you again. The query works great and that is what I wanted. Now I have a question about compare the database. I'm not 100% sure how to do that and should I do it in MySQL or PHP. If I want to take the result from what you show me and compare it to template table and display the missed or added shifts. What should I look for. I'm still new so some of the code that you typed in is very helpful to me. I really appreciate your help.

Thank you very much Mr.(Ms.)Wildbug. I will give it a shot. Still trying to solve this problem today.

Hello, I'm a staff at the university and working on PHP project. I have a difficulty of understanding and find a way to solve the problem that i have been looking at it for more than a week now. I would like to have some advice from expert and hopefully you guys can help me through this problem. Thanks in advance. Here is what I want to do. I have two main tables that contain all sort of data. The first one contain a template of staff schedule. This one shows times and id for staff. Next one is a weekly schedule. This one contain a weekly schedule where staff can add their hours. Where they work, from what time to what time that they work, etc. Last one is a Name ID Now what I would like to do is to have the first table as a template and compare it with weekly schedule. If there is a missing shift or added shifts, it will shows on the PHP page. So on a weekly database, it will take the end of the week and compare to 7 days template. I don't know how to compare it and the problem i see is weekly schedule only contain 8:00-10:00 (for example) but not 8:00, 8:30,9:00.9:30 and so on. How do i compare it? I'm not sure that I explain it clear enough. If you have any suggestion or advice or even a link direct to where i can read about how to code this. Please let me know, I am greatly appreciate your help. Thank you again.