Well, the ON condition is typo'd. Sorry about that ...
```
select name
from (
select nameid
from allnouns
union
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.