I have four fields in two different tables. ID, field1, field2 and field3 in Table 1 has value 1 or 0. Type integer. ID, field1, field2 and field3 in table2 are text fields. If field1 in table1 has value 1, then there should be a text value in corresponding field in table2. That is, in field1 in table2. However, if there is value 0 in field1 in table1 there should not be any value in the corresponding field in table2. Now it is not always so, which do that I want to make a track of which fields miss match in these two tables. How do I list them on the smartest ways? ID links the tables.