You're going to have to do a left join from the table to itself. The LHS resultset will have 'SourceSystem = 3' and it will join to records with 'SourceSystem = 1' (as well as other join fields)