Thanks, next time ill be sure to do the excel import table way so i dont have to do a huge query.

awesome that works, thanks.

I tried this query, but its still not pulling the correct information. I think ive got the wrong columns or something. Because its pulling 7k people most of which actually...

The two tables dont actually have any corresponding columns which is why its making this so hard.

atleast as far as i can tell there arent any.

Nevermind, I got it working....