AnsweredAssumed Answered

Join two query list

Question asked by domiowa on Oct 1, 2018
Latest reply on Oct 11, 2018 by reiva13

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

Outcomes