I am working with the SSDI released in 2013 and another death record. However, when trying to see how many records match by SSN I am getting zero results returned. Here is the code that I am using:
select allcalSSNs.Last_name,allcalSSNs.First_name,allcalSSNs.ssn from ssdm JOIN allcalSSNs ON allcalSSNs.SSN = ssdm.ssn
I have even tried a sub select when also returned zero results.
I have never ran into this issue before with any table I have tried this on.
there are approximately 9,000,000 records in the allcalSSNs and there are about 91,000,000 in the SSDI.
I could really use some guidance on this since I know there are some examples that should be in both.
What I have tried:
Already stated in above sentence: both sub select and inner join/join method.