i'm running the query from vb

if i run the query in enterprise manager, it all works loveley and nice wonderful etc

if i remove the WHERE bit, it won't work.