07-18-2017 1:19 PM
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!
Thanks in advance for the help!
James