All pastes #624855 Raw Edit

Mine

public text v1 · immutable
·published 2007-07-18 16:02 UTC
rendered paste body
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
left join Login j3 on j1.SubmittedBy = j3.ID
left join Login j4 on j2.AssignedTo = j4.ID
where j1.ID = '2' and j2.ID = '2' limit 1