join with superclass is outerjoin, bis.