I have a database where I'm trying to find inconsistencies across two tables. I'm new to SQL and would like some help. The other questions I've looked up are confusing and too convoluted for what I'm trying to do.
Here's the situation: I have two tables where an ID is listed. I need to find the rows in each table for which there is no match in the other table. For example, table 1 would have a list of 1, 3, 4, 5, 7, 8, and 10. Table 2 would have a list of 1, 2, 4, 5, 6, 8, 9, and 10.I need to run a query to find the entries for 3, 6, and 9, since these are the entries that only appear in one of the two tables.
In my situation, it would be thousands of numbers. So, how would I go about finding the mismatches?