• I´m not sure what to say. You should know the deal by now. We need DDL, sample data and expected results.

    The query that I posted gives the exact same result as the query you posted. You would need to post sample data to demonstrate how the query is malfunctioning and how it should return the results.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2