SELECT C.CitationID As C_ID, S.Name AS Source, E.EventID AS E_ID, C.OwnerType AS C_Type, FT.Name AS F_Type
FROM CitationTable AS C
        LEFT JOIN
     SourceTable AS S ON S.SourceID = C.SourceID
        LEFT JOIN
     EventTable AS E ON E.EventID = C.OwnerID
         LEFT JOIN
     FactTypeTable AS FT ON FT.FactTypeID = E.EventType   
WHERE C.OwnerType = 2  --  AND E.EventID IS NULL         
ORDER BY S.Name;