hi all,
i need to display time table for students and staff my table design looks like
--------------|
timtable
--------------|
classid
hour
subjectcode
day
--------------|
--------------|
Working hours
--------------|
hour
starttime
endtime
--------------|
--------------|
timtable
--------------|
classid
hour
subject code
day
--------------|
--------------|
subjectmaster
--------------|
subjectcode
subjectname
subjecttype
.
.
.
--------------|
--------------|
staff alloction
--------------|
subjectcode
staffcode
--------------|
now i need to combine all these tables and display the time table could any one guide me to do this ..
thanks in advance