Tag Archives: compare

Compare two tables/fields

Found this somewhere on google. If we need to compare two tables, this query will list the missing records on one of them (on table2): SELECT t1.id FROM table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.id WHERE t2.id IS NULL Then you do it the other way around to check the mising records… Read More »