Skip to Content
0

Oracle SQL Command External JOIN

Jul 18, 2017 at 12:19 PM

22

avatar image

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

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers