That's correct yes. The join is on the Event. And technically yes, if there is more than one record in a there is more than one classification in the result...

It doesn't, I'm afraid. 10100005 is still excluded because it has more than one record filling the criteria in the master_tix_header table even though both records are of type O.