Now looking at the post here Luis has given you the answer you need. You need the use the CTE he gave you. I just tried it, and it worked fine.
Have you tried working out how to use the 2 together?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk