Double Lines In The Tables

Hi all we are student of university
and we trying to make application

We are programming in Tsql.we must make a list of backup sets and backup jobs.

Every backupjob can have more then one backupsets. The problem is when we want to put this in table then. We see the costumors name double in it .

For excample

Mr Jurgen has more backupjobs

We see then in our table then

Loginname Wich Status
MRJURGen SET 1 GOOD
Mrjurgen Set 2 Good
Mrjurgen Set 3 NOT ok


What we want that comes like this in a table

Loginname Wich Status
MrJurgen Set 1 Good
Set 2 Good
Set 3 Not ok

But we keep getting MRjurgen in also in the other lines !

The solution that we think that could help is an while loop

But sadly it doesnt work

So we desperate asking here how to do this :(

Thanks

Students