Mine

select j1.Status, j3.ID as SubmittedByID, j3.DisplayName as SubmittedByName, j3.UserName as SubmittedByUserName, j4.ID as AssignedToID, j4.DisplayName as AssignedToName, j4.UserName as AssignedToUserName
from TroubleTickets j1, TroubleTickets j2, Login j3, Login j4 where j1.SubmittedBy = j3.ID and j2.AssignedTo = j4.ID and j1.ID = '2' and j2.ID = '2'