SQLite Forum

union vs left join for select
Well, the ON condition is typo'd.  Sorry about that ...

select name
  from (
         select nameid
           from allnouns
         select nameid
           from allverbs
       ) as T
  join names
    on names.nameid == T.nameid

This is just the same as your first query but does it differently.