do joins on rs_ids