i'm facing problem in formulating a query.I have to list number of people who are available during a current period.this period is the start date and the end date between which the employee is available. The back ground is that an employee can work on more than one project at a time. He/she may have different percentage of utilization working in that project but at no point of time will the %utlization be greater than 100.Now if i have to select the list of employees who are available from say a particular date to another particular date. the employee availability will be checked against his project start date and project end date. also since an employee can work on more than one project he/she will have different start dates and end dates for different projects so his/her % utilization will be different. what i have to find out is to formulate a query which gives me a list of available persons along with their % of utilization during the start date and the end date which will be entered by me.The check against availability will be made against the project start and end dates of different projects the employee is currently working on moreover with the constraint that % of utilization should be less than 100. please help me.