Hi Phill.

Thanks for the reply.

When I tried to run the above query i get the following error message:

Server: Msg 107, Level 16, State 2, Line 2

The column prefix 'a' does...