Skip to Content
avatar image
Former Member

Oracle SQL Command External JOIN

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers