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...