SELECT C.CitationID As C_ID, S.Name AS Source, F.FamilyID AS F_ID, C.OwnerType AS C_Type
FROM CitationTable AS C
        LEFT JOIN
     SourceTable AS S ON S.SourceID = C.SourceID
        LEFT JOIN
     FamilyTable AS F ON F.FamilyID = C.OwnerID 
WHERE C.OwnerType = 1 -- AND F.FamilyID IS NULL         
ORDER BY S.Name;