• Use COLLATION clause in one of the joins .. 😉

    If you have a database with a different collation like me, you'll get that error.