problem converting this query to oracle

[davey23uk]

format your code using the [ code ] and [ / code ] tags, it's really hard to read otherwise