SQLite Forum

How to select entries from second table that either do not have an entry or do not have a specific entry?
Login
Translated from the English description of how to solve the problem into SQL:

```
with cross 
  as (
      select A, B 
        from (
              select distinct A 
                from one
             ), 
             (
              select distinct b 
                from two
             )
     )
select distinct a 
  from (
        select * 
          from cross 
        except 
         select * 
           from two
       )
;
```

Of course, "coding" the SQL is quite simple and proletarian once one has defined the problem solution (what programmers do).