If the user selects “Keep Matching Records” rather than the default, “Keep All Records”, the expected number of records will be returned.The correct result can be obtained by building a query that includes both sides of the join.GK200SP1.OBJECTID IS NOT NULL AND GL500.LITHOSTRAT1 = 'Gosau-Puppe'