I'm starting with Database, and I came across a situation that I just do not understand.
I wanted to get the name of the student and the name of the subject that are in table 3 in the case " TbMateriasAluno
"
I used this Select command but it did not work
Select TbAluno.NomeAluno , TbMaterias from TbAluno Inner Join
TbMateriasAluno On TbMateriasAluno.ID_Aluno = TbAluno.NomeAluo
I have 3 Tables.
TbAluno Table:
|---TbAluno---|
*ID
*NomeAluno
|--------------
Table TbMaterials:
|---TbMaterias ---|
*ID
*NomeMateria
|--------------
and the TbMaterialsAlumn table
|---TbMateriasAluno---|
*ID
*ID_Aluno
*ID_Materia
|--------------