select dotlrn_communities.community_type, dotlrn_communities.pretty_name, dotlrn_communities.description, groups.join_policy from dotlrn_communities, groups where dotlrn_communities.community_id = :community_id and groups.group_id = :community_id