Oracle SQL Command External JOIN

Jul 18, 2017 at 12:19 PM|31 Views

To the Community:

I am currently developing a CR 2008 report (yeah, I know we're dinosaurs) where I am attempting to filter a social security number that exists in one table but not in another. I currently am running the following SQL statement against our Oracle DB:

SELECT PLANEE.PLANID, PLANEE.SSNUM, PLANEE.YRENDDATE FROM PLANEE WHERE PLANEE.PLANID='compid' AND PLANEE.YRENDDATE='2017-12-31' AND PLANEE.SSNUM NOT IN (SELECT PLANEECONTRPCT.SSNUM FROM PLANEECONTRPCT WHERE PLANEECONTRPCT.PLANID='compid')

Submitting the above statement directly to the DB returns the single correct record. I have now created a CR Database Command utilizing the above SQL as my record source but, returns no records. Any guidance in the right directions is greatly appreciated!