There really is no direct Join Opportunity here, in situations like this I need an intermediary table
|
stlanguage |
|
|
languageID |
|
|
languageName |
|
|
languageAltName |
|
|
languageCharacterSet |
|
|
languageExample |
|
lifeform |
|
|
lifeformID |
|
|
lifeformName |
|
|
homeworld |
|
|
environment |
|
stlanguage.languageName to speaks.languagename AND speaks.lifeformName to lifeform.lifeform.name
|
speaks |
|
|
speaksID |
|
|
lifeformName |
|
|
languageName |
|
And even this is an oversimplification, races do not “speak” individual people “speak”