PS: I know this uses the 'no join predicate', but the query is based on the 3rd party apps workings - I ran a profile trace to capture what one of the front-end reports was doing to adapt to our needs (the front-end only allows reports for single items, in this case months).