Hi Everyone

This the results from my querries

Lists 1:

Name          Role  

Tom             PM

Maxime        Head of IT

Alan             Business Owner

List 2:

Name     Status

Tom        Approved

Max         Rejected

Alan         Not required

So now, I'd like to do a join Where my role is equal to Head of IT or PM, I tried some things but nothing works

Any idea of what I could do?

Thanks in advance for your help