Page 1 of 1

need some help regarding query

Posted: Sun Jul 05, 2009 9:22 pm
by greedyisg00d
Sorry guys my topic title seems irrelevant because I cannot think of any other title for it. Anyways I am currently working on some sort of a scheduler which all data are stored into a database. My problem is my manager wants a function that goes like this:

Employee A - has a business trip for Week 1 of July
Employee B - has a business trip for Week 3 of July
Employee C - has a business trip for Week 4 of July

Thus my manager wants to know which date will all the employees will be available which in this case it will be in the 2nd week of July. Sample codes is much appreciated so that I can work or play around with it.

Thanks in advance