SELECT 
 N.OwnerID AS Rin ,
 N.Suffix COLLATE Nocase ,  
 N.Given COLLATE Nocase , 
 N.Surname COLLATE Nocase ,
 N.Prefix COLLATE Nocase , 
 L.extID AS FSID,
 F.Name As Fact
From
 Nametable N,
 Eventtable E,
 LinkTable L,
 FactTypeTable F
Where N.OwnerID = E.OwnerID AND N.OwnerID = L.rmID AND E.EventType = F.FactTypeID AND E.Ownertype = 0 AND +N.IsPrimary And E.Proof = 0
ORDER BY 
  RIN ;