I have a table with 3 cols
the pluralId points to the id of another word in the same table.
can I select in a single query the word (singular) and its plural version?
this works, but it seems very complecated, there must be a better way.
or maybe I have to put the plural ver of the word in the 3rd col instead of the pluralId?
select a.word,(select b.word from words as b where b.id=a.pluralId) as plural from words as a where a.id=64