Thanks guys, i've managed to solve it

thanks

Hi I've just ran the view ,

it is working onw.

thanks everyone

to create the view, I've gone into the management studio and selected view - new view and copy and pasted the above SQL statement into it. I've saved this...

i don't understand. I created a select statement ehich worked and then tried to create a view which involved copying the select statement

regards

R