• I have a question, have you tried recreating the problem using a set of tables that resemble the tables used in the query (data types and column order) with a similar query joining the on columns of the same data types?