Sql joins & union problem

Thank you Scot and Jatore. I figured out my problem. The query I modified with Jatore worked. I just had no record called 'EdsWorld' in the column AccountName

That's why it came up blank.

Thanks a ton everybody. Steaks on me tonight in riverside, ca