Проверьте две разные таблицы

Вы можете использовать anti join, а затем union, если Id соответствует вашему свойству:

union
  (Table1
  | join kind=anti(
    Table1
    | where Source = 1 and Name == "ABC" and Number in ("123", "456"))
    on Id),
  (Table2
    | join kind=anti(
      Table2
       | where Source = 1 and Type == "Misc")
    on Id)

-- Anti Join: Select records from TableA that do not exist in TableB
SELECT a.*
FROM TableA a
LEFT JOIN TableB b ON a.Id = b.Id
WHERE b.Id IS NULL

UNION

-- Select all records from TableB
SELECT *
FROM TableB;