A Small Query Problem

Hello All,
I have a database and I am trying to run a query against it, it returns the data fine, I just want it displayed differently. Here is the example; I am a novice at SQL I dabble here and there so any help would be great!

Base Code
Select LOA.Account0 as 'Account Name'
From local_accounts LOA
Where LOA.Account0 like '%Microsoft%'
Group by LOA.ACCOUNT0


Account Name
Win32_UserAccount.Domain='Microsoft',Name='Jason'


I would like the data to be displayed differently in my query. I would like just the domain user name to appear in the row.

Account Name
MicrosoftJason

Does anyone have example code of something like this.