Can I do this with a view?

Hi,

I have Table Unit_Day_Shift:

Unit_ID Day_Date Shift_SN Run_Hours

123	1-Jan		1		2
123	1-Jan		2		4
123	1-jan		3		0
345	1-jan		1		0
345	1-jan		2		2


..

123	2-jan	...

I need Table Unit_Day:

Unit_ID Day_Date Shift_1_Hours Shift_2_Hours Shift_3_Hours

123	1-Jan		2		4		0
345	1-Jan		...

(I also have---

Table Day:

Day_Date

1-Jan
2-Jan
3-Jan

and Table Shift:

Shift_SN Start_Offset_Hours End_Offset_Hours

1		0			.333
2		.333			.666
3		.666			1

Is this doable with a view?

Thanks,
Tom Received on Thu Jul 18 1996 - 00:00:00 CEST