Outputting two different values ​​from two different tables linked by a third?

Question

SQL

How can I display the number of the specialty and the last name of the student

Answer 1

JOIN
If anything - JOIN can be chained, that is, table1 JOIN table2 ON ... JOIN table3 ON ...

Answer 2

select st.surname, s.spcode
from st_student as st
join st_student_spec as sst on st.id = sst.student_id
join st_spec as s on s.id = sst.spec_id

If we take into account the structure that a student can have different specialties (but the data in the example is still curves, there should not be complete duplicates in the student.specialty)