How to Select Distinct IDs from One Table Based on Rules from Another Table