Calculated columns across tables

Hello

How do you do a 'not equal to' across tables?

I have 2 tables. Table 1 has columns: Unique ID, Field A & Field B.

Table 2 has Unique ID only. 

I need to create a column in Table 2 that returns "Pass" or Fail", depending on what is in Table 1, Field A and Field B. For example:

if Table 1[Field A] equals "1" or "2" or "3" or "4" and Table 1[Field B] does not equal "1" then "Fail"

OR

if Table 1[Field A] does not equal "1" or "2" or "3" or "4" and Table 1[Field B] does equal "1" then "Fail"

Thankful for any help