Posts by Helio Cassio • 26 points
1 post
-
1
votes2
answers55
viewsA: Give an input in a table with information from two tables
Could remove the student table | id_alu | nome | turma | 1 | aluno 1 | 2 | 2 | aluno 2 | 1 then put the following sql INSERT NOTA SELECT AL.ID_ALU, M.ID_MAT FROM aluno AS AL JOIN materia_turma AS MT…