I'm a beginner with SQL programming, so please bear with me. I'm
having the following issue:
SELECT table1.id FROM table1, table2 WHERE table1.id<>table2.id
For whatever reason this query returns two of each id from table1
except where it equals the id from table2, in which case it only
returns one id.
The id columns contain unique values and I don't understand why it's
returning two of each instead of one row for each id that doesn't
match the IDs from table2. I just want all the IDs that aren't also in
Any help would be appreciated. Thanks!...