Code:
SELECT A.*
FROM TableA A
LEFT JOIN TableB B
  ON A.Fields2 = B.Fields2
    AND A.Fields3 = B.Fields3
    AND adddate('Date Value', A.Fields4) = B.Fields4
WHERE B.Fields1 IS NULL
A simple left join to return rows that are not found in table b


TG