There are many different ways you can write the SQL for this, the SQL above looks like it should work as you grabbed it from the "View SQL" action.
Below is a what I just wrote and ran fine, see screenshot.
left join EPOProdPropsView_VIRUSCAN b on a.AutoID = b.LeafNodeID
b.verDAT32Major = 7640
datversion.png 133.6 K
That's the tricky part, I don't want to mention any numbers and have it pick it from the current branch in the master repo or whichever branch I choose it from.