> Then, for a small subset of data, I manually verified that all results were correct. This could have been automated with a full join. with A as queryA, B as

> Then, for a small subset of data, I manually verified that all results were correct. This could have been automated with a full join. with A as queryA, B as queryB select A full join B on all applicable fields where A is null or B is null. Alternatively, you could also do: A except B union all B except A. Either way you get the rows in A that aren't in B and rows in B that aren't in A -- no manual check needed, and you could have run that on the entire set instead of or in addition to counting rows.