if function 3 conditions from different table

Hi,   I have two tables REFERENCE and CALL I want to add a conditional column to the table CALL with True and False based on three conditions. 2 of the conditions are in table CALLand 1 in TABLE RE...