vba to sql

[menssanvi]

I've attached a sample result.
"result from my current sql" is basically what I'm getting when I try to write it in sql
"result from VBA" is what it should be.

the yellow section is where my data is not matching for this particular case when cluster no is 14.