Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have three tables:

  • Entry
  • Manager
  • Employee

The Entry table has as date field and a bunch of other fields about the entry including the emp_id.

Manager Table has columns:

  • Manager_id
  • Manager_name

Employee Table has columns:

  • Emp_id
  • Emp_name
  • Man_id

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?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.