What are you talking about?

On the face of it, the query looks like a simple join with suitable criteria. There is no cartesian product begin generated.

How would you rephrase the query to avoid the problem you allege exists?