One-to-Many links/joins

Given that ATS’ usually are database driven, I would like to see the ability to have push button queries resulting in a single candidate being able to match all job requirements. The ability to filter against the job requirement’s status (active, closed, etc.)