Here is an example of my question
I have a column called Department, a column called Employee Name and a column called EmployeeAbsent.
Obviously i can easily use a select satement to get each employee's absent status. However, I would like to generate an additional field called DepartmentAbsent to see if anyone in a particular depart is absent based on the EmployeeAbset field.
how should I write the query?
View Complete Post