This copy paste is barely legible, you've got column headers on a line and then a run on sentence of information that isn't even formatted to be read. Heck one of the lines says 'oon' at the end where the alias is o and the next word is on.

SELECT distinct

o.VP,

o.AVP,

o.Director,

o.Supervisor,

o.Worker,

bs.File_NBR,

s.Skill,

bs.score

FROM New_EEs.dbo.SBC_Best_Scores bs

inner join new_ees.dbo.SBC_Skills s

on bs.Skill_NBR=s.SKILL_NBR

inner join gw_PPP.dbo.Org_Hierarchy o

on bs.File_NBR=o.File_NBR;

So you've got some tables here. I see they join on file number and skill number. What other columns do they have? Three tables, what's the information for all three of them?

Some more data is required here. Thank you.