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