select f.name, nr.resource_namefrom ca_owned_resource as nrleft join ca_resource_family as f on f.id = nr.resource_family