hi..
Im new to mysql..i want to know how to generate daily reports for all employees
i created 3 tables with fields
employee table:emp_id,name
job table:job_id,job_name
activity table:act_id,emp_name,job_name,date,activity done(assigned values as email,phonecall,visits)
Daily Activity Report : (Employee ID, Emp Name,Jobs Name, Activity Done)
Eg: 1.| Date | Rajeev | Income Tax Filing | Phone Call
Options to Select : 1. Which Date (Required - Not Null) 2. Employee Name,
if Employee Name not selected, then the list of Activities for that day for all Employees.
How to write query