with the company code different on every row then it will bring back each company code! remove that column and it works.

you could try looping around and using 'Top 1'...