SQLite SQL! =

Question

Good day.
There are two tables, you need to select the values that are in one table, but not in the other

SELECT groups._id, groups.group_name FROM groups INNER JOIN test ON groups. _id != test._id

so

  SELECT groups._id, groups.group_name FROM groups , test WHERE groups._id != test._id

but lists all the entries in the groups table.

gadfil gadfil 2.376 one eight 22 · Answer 1 · 2013-09-21T10:30:40

Figured out

  SELECT groups._id, groups.group_name FROM groups LEFT JOIN test ON groups._id = test._id WHERE test._id IS NULL

1 answer 1