[ https://issues.jboss.org/browse/TEIID-4802?page=com.atlassian.jira.plugin... ] Bram Gadeyne edited comment on TEIID-4802 at 3/9/17 9:32 AM: ------------------------------------------------------------- Hi Steven, Yes, The query "select WSidentifier from prod_U_PV_PClist" returns 96 results where wsidentifier is unique (for non null values). and 2 where wsidentifier is null. The query "select cl.hostname from izalert_clientstatus cl" returns 123 results where hostname is unique. If I change the subquery to "select WSidentifier from prod_U_PV_PClist where WSidentifier is not null" then I to get the desired results. Could the null value be causing this? was (Author: gadeyne.bram): Hi Steven, Yes, The query "select WSidentifier from prod_U_PV_PClist" returns 96 results where wsidentifier is unique. and 2 where wsidentifier is null. The query "select cl.hostname from izalert_clientstatus cl" returns 123 results where hostname is unique. If I change the subquery to "select WSidentifier from prod_U_PV_PClist where WSidentifier is not null" then I to get the desired results. Could the null value be causing this? -- This message was sent by Atlassian JIRA (v7.2.3#72005)