Select from a table that is not in other table

If I understand you correctly, then you can do this with 2 queries, for example, I made this right now for you:

  1. Table 1
    image
  2. Table 2
    image
  3. First query:
    image
  4. Second query:
    image
  5. The condition of the second query:

Which is:
query.join(',', 'user').split(',')
The results are:
image

You can see that the second query doesn’t have user1/user2/user3 because they are on the first query.

1 Like