Sub-Query in MetaMatrix with NOT IN returns zero results but there should be

Solution Verified - Updated -

Issue

  • Running below query should return some rows since there are lot of records from results of main query doesn't exist in the results of sub-query.  But running this query in MetaMatrix is returning 0 rows.

    SELECT a.* 
FROM ERStudio_Repository_View.DMREPO4.REPO_USER AS a
WHERE a.unix_nm not in (select b.user_id
                                 from Public_Views.PEOPLE AS b)

Environment

  • MetaMatrix Enterprise Server 5.5.4

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.