Join Column row names from the same table

Hi Everyone, 

I have a table (quote log table) that only shows me the name source (user table) of who had created a quote when a quotelog has gone through S1 = status 1  

I want to be able to still see the name source of who created that quote when the same quotelog has gone through a count of S9= Status 9 

Problem is that the only time i can see the name source is when a quote has gone through status1, after that, the name (from the user table) disappears and all the quotelogs that follow of that quote ID will not have a record of the name.   

How can i make it so that each of these quote ID's always show the name source, even if i dont choose "status1" 

                                                                                                                           to help me see it. 

Thanks in Advance!