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'For more information, read this technical article: <a href="http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=22132" target="_blank">http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=22132</a>