I would have the same EIN & Name combination listed out for both years, that's the way the table was set up. Is there a way to do it? Or...

Thank you! What if instead of DISTINCT, I want to say put these data in new table if fiscal year = "2017"?

Thank you! So I want to read the unique values from table B and put it into the new table I created. How do I do that?

This is what I...

Thank you that makes sense! Do I just create another table C to store EIN and Name and try to link A to C instead? Can you show me an...