I have three tables:
The Entry table has as date field and a bunch of other fields about the entry including the emp_id.
Manager Table has columns:
Employee Table has columns:
I would like to have a table that has a list of Employees going across the top (I know it could get big). The Employees would be under the Manager choosen. So my columns are based on Emp_id.
The rows are dates. Based on the current date or whatever. Inside of each date to Emp_id crossing is some chosen fields for that Entry, for that date.
Can this view be created in MySql or do I need to do it by coding?