Query analyzer tells me it does 'left semi join' which is subtly different from 'inner join' because its based on number of columns in the left table, not arbitrary filter expression of full cross-product.
But I think it's equivalent in this case since the join is a key lookup and keys will be uniquely referenced.