>Hello Daniel,
>I tried it ( full of hope ) but no joy I'm afraid
>
>regards
>
>Pete

Pete --

Try simplifying until it works.

i.e. -- first, drop the CREATE VIEW stuff and just work with the SELECT. That's a lot easier to debug.

Jay