Thank you, that seems to have solved the issue

I assume I have put it in the correct place...

ISNULL(STUFF((SELECT ', ' + d.POSTCODE

...

Thank you very much for your help Thom and Phil.

It seems to be working now for the most part but there seem to be random jobs appearing in the view...

Thank you Thom,

That appears to be nearly there the only problem now is if a job doesn't have any additional drops it doesnt show the collection and delivery post...

This is a sample of what the the drops table looks like

DROPIDJOBIDDROPNOTYPE POSTCODE

567 4443421 ...

Hi Thom,

Thanks, I have edited the post.

I am not sure how to post samples with DDL?