因此,基本上,我正在關(guān)注一個教程問題,該問題問我以下內(nèi)容。我不太確定如何聯(lián)接不包含其他FK的2個表,它們(即它們的兩個FK)都位于第3個表中。我可以得到一些幫助/解釋嗎?我的答案SELECT Forest.Fo_name, Species.Sp_name, Species.Sp_woodtypeFROM ForestINNER JOIN SpeciesON Tree.Tr_species=Tree.Tr_forestWHERE Fo_loc='ARTIC'ORDER BY Fo_name, Sp_name“對于在編碼為“ ARTIC”的區(qū)域中找到的森林,列出其中找到的森林名稱和物種名稱以及物種木材類型。消除任何重復(fù),并按森林名稱和物種名稱對輸出進(jìn)行排序”種類表+--------------+------------------+------+--------------------------------+| Field | Type | Key | Glossary |+--------------+------------------+------+--------------------------------+| sp_name | C(10) | PK | Species Name || sp_woodtype | C(10) | | Wood Yielded by tree || sp_maxht | I | | Max. Height |+--------------+------------------+------+--------------------------------+森林表+--------------+------------------+------+--------------------------------+| Field | Type | Key | Glossary |+--------------+------------------+------+--------------------------------+| Fo_name | C(10) | PK | Forest Name || Fo_size | I | | Forest Area || Fo_loc | C(10) | | Geographical Area || Fo_comp | C(10) | | Forest Owner |+--------------+------------------+------+--------------------------------+C(10)&我分別代表字符(10)和Integer
添加回答
舉報(bào)
0/150
提交
取消