find the unmatched records between two tables

Discussion created by msteinbrenner on Aug 11, 2011
Latest reply on Aug 11, 2011 by jmward
so i am looking to replicate the "find unmatched query wizard" from microsoft access in python.

basically i have 2 tables and i want to output all the records from the one table that do not match the records of the other table based on a common ID.

in theory it seems simple enough but i can't figure out how to do it.

any help would be greatly appreciated!