SQL Server :: Create A Complex Query And Bind It To A Repeater?

I have written a web project using Visual Web developer 2008 and SQL 2005. I need to create a complex query and bind it to a repeater.

I have 3 tables

Table 1 - Department
Dept_Id (int) primary key
Dept_Name (vchar)
Include_Unavailable (bit)
Table 2 - Employee
Employ_Id (int) primary key
Dept_Id (int) foreign key
Employ_Name (vchar)
Table 3 - Schedule
Sched_Id (int) primary key
Employ_Id (int) foreign key
Date (datetime)

My query is as follows:

SELECT Department.Dept_Name, Employee.Employ_Name, Schedule.Date

FROM Department, Employee, Schedule

WHERE ??

In my query I want all departments and employees listed who work on a particular date. In addition, if the Department.Include_Unavailable is 'true' I want to create a row with the department and employees who work in that department even if they are not schuled to work. I will eventually list these employees as 'unavailable' but do not want to list all unavailable employees as unavailable. Only employees that work in departments that have Department.Include_Unavailable set to 'true'