frebe73_at_gmail.com wrote:
> I have a number of tables as below:
> employee(*employeeid, ....)
> schedule(*scheduleid, recur_interval, ...)
> emp_schedule(*employeeid, *scheduleid, *valid_from, valid_to)
> workshift(*scheduleid, *shiftid, starttime, endtime)
>
> recur_interval indicates the number of days for which the schedule
> should recur.
> starttime and endtime indicates the first occurrence of the workshift.
>
> Now I want to create a view (without using stored procedure) that
> returns every occurrence of the workshifts for every employee, like
> below.
>
> create view emp_calendar as
> select
> employeeid,
> starttime,
> endtime
> .....
>
> Does someone has a solution (preferably MySQL) for this, or is it
> simply impossible?
I suspect you left out a few details from your question. For instance,
it appears a natural join on emp_schedule and workshift suffice for your
view.
Received on Fri Aug 11 2006 - 08:45:15 CDT
