Hi Oh Great Grasshopper

It worked once I also added t5.weekday & t5.weektype to the group by clause.

Many Thanks, Very grateful for your help.

Enjoy the rest of your day. Julian

SELECT...

Hi Grasshopper

Many Thanks for your help and replying, it makes sense what you said, but when I added the IsNULL as you kindly suggested I got this error..

Msg 4104, Level...

Hi Grasshopper

Thanks for replying and offerring your help, I have tried a Full Join before, but when I use a full join the weekday Tuesday is replaced by a NULL...