Hello,

I have 2 sql statements
1) select count(task_id) as count_task from tbl_employee_task,tbl_employee where
tbl_employee_task.employee_id = tbl_employee.employee_id group by task_id

2) select count(todo_id) as count_todo from tbl_employee_todo,tbl_employee where
tbl_employee_todo.employee_id = tbl_employee.employee_id group by todo_id

now what I want to display is a list with all the employees who have tasks + todo

is there a way to do it in one sql statement?

thanks!